Hi,
Could you provide me an example of Excel reader and writer library (https://docs.safe.com/fme/html/FME_Desktop_Documentation/FME_ReadersWriters/xlsx/xlsx.htm)?Is the library MS Excel version dependent (2011, 2013 etc.)? The process involves reading data from some of the geometrical shapes. Is this feature supported?
Thank you !
PS: C++ is preferred.
Best answer by mark2atsafe
Do you mean that there is actually a shape object placed into Excel that you want to read? Or is it spatial information in the form of coordinates? If you have a sample Excel spreadsheet you can provide it would help.
It should be pretty easy to read coordinates and turn them into spatial features. Generally in FME we use a tool called Workbench to do that. If you then absolutely need to do the task programmatically, you can run the workspace using a method called iFMEWorkspaceRunner.
Check out the help and other information in <FME install folder>\\fmeobjects\\cpp - but seriously don't start trying to recreate the Excel reader in C++ unless there's a really good need for that. It's much easier to do in Workbench.
+59Do you mean that there is actually a shape object placed into Excel that you want to read? Or is it spatial information in the form of coordinates? If you have a sample Excel spreadsheet you can provide it would help.
It should be pretty easy to read coordinates and turn them into spatial features. Generally in FME we use a tool called Workbench to do that. If you then absolutely need to do the task programmatically, you can run the workspace using a method called iFMEWorkspaceRunner.
Check out the help and other information in <FME install folder>\\fmeobjects\\cpp - but seriously don't start trying to recreate the Excel reader in C++ unless there's a really good need for that. It's much easier to do in Workbench.
Thank you for the response.
I have attached an image for your reference. Read data from each column including geomertric shapes, write only alphanumerical values to an Excel file. Excel file reading is also included for further processing. Could you please suggest a suitable library?
Regards,
Pooja B
