[Solved] - Problem saving a grid as Excel Format

[zxandris]

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][+][-]

1. wsSheet.SaveToSpreadsheetFile(dlgExport.filename, sfExcel8, true);
2.  

That's the code I'm using and I have

Code: Pascal  [Select][+][-]

1. fpspreadsheetgrid, fpspreadsheetctrls, fpsTypes,

in the uses clause for the unit/form.  Can anyone tell me what I'm doing wrong here please?

CJ

[wp]

What is the error? What type is wsSheet?

[zxandris]

Tried to write a spreadsheet using an unsupported format and wsSheet is a simple tsWorksheetGrid.

[wp]

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]

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]

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]

Thanks for the tip!