Forum > FPSpreadsheet
[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 [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---wsSheet.SaveToSpreadsheetFile(dlgExport.filename, sfExcel8, true);
That's the code I'm using and I have
--- Code: Pascal [+][-]window.onload = function(){var x1 = document.getElementById("main_content_section"); if (x1) { var x = document.getElementsByClassName("geshi");for (var i = 0; i < x.length; i++) { x[i].style.maxHeight='none'; x[i].style.height = Math.min(x[i].clientHeight+15,306)+'px'; x[i].style.resize = "vertical";}};} ---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!
Navigation
[0] Message Index
[#] Next page