Whats New in 5.52 (SE)$$$LINQPad 8s new Excel export engine has had most of its features backported into LINQPad 5; so you can generate native .xlsx files rather than relying on HTML or CSV. This ensures reliable handling of DateTimes and extended Unicode characters; the preservation of leading zeros in string data (such as phone numbers); and the generation of multi-sheet workbooks. You can export via .xlsx interactively by right-clicking a DataGrid; or programmatically by calling the .ToSpreadsheet extension method; followed by Open() or Save(...):$$$customers.ToSpreadsheet().Open();$$$$$$salesQuery.ToSpreadsheet().Save (salesQuery.xlsx);$$$The Save method does not require Excel to be installed on the machine. To generate a multi-sheet workbook:$$$customersQuery$$$ .ToSpreadsheet (Customers)$$$ .AddSheet (ordersQuery; Orders)$$$ .AddSheet (profitsQuery; Profit and Loss)$$$ .Save (@c:\temp\export.xlsx)$$$ .Open();$$$Spreadsheets can also be populated manually:$$$var sheet = new Worksheet // Worksheet is in the LINQPad.Spreadsheet namespace.$$${$$$ [1; 1] = Revenue;$$$ [1; 2] = Expenses;$$$ [1; 4] = Profit;$$$$$$ [2; 1] = 150230;$$$ [2; 2] = 25010;$$$ [2; 4] = new Cell { Formula = B1-B2 }$$$};$$$$$$sheet.Open();$$$// or sheet.Save (filepath);$$$Unlike with COM interop; no round-tripping takes place. For more samples; press Ctrl+F1 and type Excel.$$$LINQPad now actively monitors NuGet package references and dependencies for published vulnerabilities and gives warnings - both when choosing packages and executing queries. You can suppress warnings for specific (or all) packages in Edit | Preferences > Advanced > Execution.$$$The client libraries used by LINQPads NuGet engine have been updated.$$$Autocompletion is now less intrusive when working with tuples.$$$The undo buffer size for the editor has been enlarged by a factor of 10.$$$The PowerPoint interop method (PowerPoint.ShowSlide) now works with modern versions of PowerPoint.

Whats New in 5.52 (SE)$$$LINQPad 8s new Excel export engine has had most of its features backported into LINQPad 5; so you can generate native .xlsx files rather than relying on HTML or CSV. This ensures reliable handling of DateTimes and extended Unicode characters; the preservation of leading zeros in string data (such as phone numbers); and the generation of multi-sheet workbooks. You can export via .xlsx interactively by right-clicking a DataGrid; or programmatically by calling the .ToSpreadsheet extension method; followed by Open() or Save(...):$$$customers.ToSpreadsheet().Open();$$$$$$salesQuery.ToSpreadsheet().Save (salesQuery.xlsx);$$$The Save method does not require Excel to be installed on the machine. To generate a multi-sheet workbook:$$$customersQuery$$$ .ToSpreadsheet (Customers)$$$ .AddSheet (ordersQuery; Orders)$$$ .AddSheet (profitsQuery; Profit and Loss)$$$ .Save (@c:\temp\export.xlsx)$$$ .Open();$$$Spreadsheets can also be populated manually:$$$var sheet = new Worksheet // Worksheet is in the LINQPad.Spreadsheet namespace.$$${$$$ [1; 1] = Revenue;$$$ [1; 2] = Expenses;$$$ [1; 4] = Profit;$$$$$$ [2; 1] = 150230;$$$ [2; 2] = 25010;$$$ [2; 4] = new Cell { Formula = B1-B2 }$$$};$$$$$$sheet.Open();$$$// or sheet.Save (filepath);$$$Unlike with COM interop; no round-tripping takes place. For more samples; press Ctrl+F1 and type Excel.$$$LINQPad now actively monitors NuGet package references and dependencies for published vulnerabilities and gives warnings - both when choosing packages and executing queries. You can suppress warnings for specific (or all) packages in Edit | Preferences > Advanced > Execution.$$$The client libraries used by LINQPads NuGet engine have been updated.$$$Autocompletion is now less intrusive when working with tuples.$$$The undo buffer size for the editor has been enlarged by a factor of 10.$$$The PowerPoint interop method (PowerPoint.ShowSlide) now works with modern versions of PowerPoint.

Whats New in 5.48$$$This is the final release of LINQPad 5 to support .NET Framework 4.6. Subsequent LINQPad 5 updates will require .NET Framework 4.7.2 or .NET Framework 4.8. This is to allow a refresh of LINQPad 5s internal dependencies.$$$$$$The code editor and results panel now support horizontal scrolling via Shift+MouseWheel.$$$A regression; when using a smart-tag to add references and namespaces at the same time; has been fixed.$$$The DEBUG symbol is now defined by default in C# queries.

Whats New in 5.48$$$This is the final release of LINQPad 5 to support .NET Framework 4.6. Subsequent LINQPad 5 updates will require .NET Framework 4.7.2 or .NET Framework 4.8. This is to allow a refresh of LINQPad 5s internal dependencies.$$$$$$The code editor and results panel now support horizontal scrolling via Shift+MouseWheel.$$$A regression; when using a smart-tag to add references and namespaces at the same time; has been fixed.$$$The DEBUG symbol is now defined by default in C# queries.