[Solved] - Problem saving a grid as Excel Format lazarus / 49-FPSpreadsheet ---------------------------------------------------------------------- zxandris · 2024-08-03 16:47 I am pretty sure I'm missing something obvious but I've got a grid which is built from a simple csv (Which I had to load myself) and I want to save it in Excel Format, or another in time. Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i wsSheet.SaveToSpreadsheetFile(dlgExport.filename, sfExcel8, true);  That's the code I'm using and I have Code: Pascal  [Select][+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i fpspreadsheetgrid, fpspreadsheetctrls, fpsTypes, in the uses clause for the unit/form.  Can anyone tell me what I'm doing wrong here please? CJ ---------------------------------------------------------------------- wp · 2024-08-03 20:22 What is the error? What type is wsSheet? ---------------------------------------------------------------------- zxandris · 2024-08-03 20:23 Tried to write a spreadsheet using an unsupported format and wsSheet is a simple tsWorksheetGrid. ---------------------------------------------------------------------- wp · 2024-08-04 06:11 Did you add unit xlsBiff8 to "uses"? FPSpreadsheet has a modular structure, and for every file format the reader/writer unit must be listed, or you add "fpsAllFormats" to register all file formats. ---------------------------------------------------------------------- zxandris · 2024-08-04 06:13 Thank you very much that appears to have worked.  It does actually say as a hint it's not used in the unit, but it makes it work anyway! ---------------------------------------------------------------------- wp · 2024-08-04 06:18 Yes, that's because your code does not explicitly call any reader/writer function (this is done internally). If you'd once decide to remove "unused units" be careful to keep your reader/writer unit. ---------------------------------------------------------------------- zxandris · 2024-08-04 06:21 Thanks for the tip!