![]() ![]() Both the original file and the converted one now exist in your Google Drive account. It will automatically convert to a format that lets you read and use the file with Google Sheets. ![]() The workbook then looks up the format id in an internal list and finds the reader class this way. Right-click the XLSM file in Google Drive and select Open with > Google Sheets. The format id returned by the registration is the format parameter to be used in the ReadFromFile() method of the workbook. All what has to be done is to call "RegisterSpreadFormat()" (in unit fpsReaderWriter) with the appropriate parameters. ![]() The essential part is the file reader and writer code - but we already have it, it is the standard ooxml unit containing the TsSpreadXLSXReader and TsSpreadXLSXWriter (we don't need the latter one). For this reason - because fpspreadsheet will not handle xlsm files as expected - I think it is not a good idea to officially support this file extension.īut fpspreadsheet can be extended to user-defined file formats. Therefore, xlsm files will only provide the data part, not the code part which certainly is existent here because otherwise the file would have been written with its default extension. BUT: Macros will never (?) be executed by fpspreadsheet. So, I'd only have to allow the xlsxm extension to be accepted by fpspreadsheet and xlsm files could be read - no other change needed. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |