Reading & Writing to Excel spreadsheet

The developer version of Fusion has a "Datagrid object" which I think will do this really easily for you

Check out the file in this thread

Please login to see this link.

Unfortunately, an interesting extension but never had a significant update (update on other platforms)....,

Quote from pl

Unfortunately, an interesting extension but never had a significant update (update on other platforms)....,

what extension are you referencing?

"what extension are you referencing?"
Datagrid object version date 2006

Excel is a pain.
The older XLS format is an extremely complicated binary format, so you can basically forget about it.

The newer XLSX format is really just a zip file, containing a whole bunch of XML files, including the Worksheet XML files which hold the actual data you want.

Note that Excel can directly export just these Worksheet XML files, so if that's an option for you, it's obviously easier to do that instead of working with the XLSX file. I made an array/Excel converter years ago, which used Excel XML files. I don't remember which is the most recent, but there are a few different versions in my onedrive - Please login to see this link. (note that using the easyxml extension means they need some .dll file to work, which will be mentioned in the help files)

If you only need to work with single worksheets, rather than multi-sheet workbooks (or can export each separately), then it's going to be much easier to export the data as a CSV file, which is vastly simpler to parse. If it's at all possible, I'd go this route.

Another option is to load the file into Google Sheets, and then using a script (which can be found online), export the data as JSON, which again can be parsed relatively easily (there's a JSON extension for Fusion).

Similarly, if you have the Google Sheets spreadsheet stored in the cloud, it may be possible to access the data from it using the API, but likely not easy. I made a web-based tool (ie. written in javascript, not using Fusion) to convert between Fusion arrays and Google Sheets documents, which worked fine, except that Google has incredibly strict requirements for accessing data, so to publish it for other people to use would require jumping through a huge amount of hoops (stuff like recording a youtube video of me describing exactly what data I need to access, and the reason why, etc).

Using an ActiveX control might be an option too, although ActiveX is considered obsolete these days, and in my experience just crashes Fusion.

Maybe this example I made before can help?

.tsv to array convertor

Please login to see this picture.

Mfa: Please login to see this attachment.