Author Topic: Question regarding interacting with Excel files  (Read 1879 times)

0 Members and 1 Guest are viewing this topic.

Offline LM

  • Newbie
  • Posts: 28
Re: Question regarding interacting with Excel files
« Reply #15 on: April 08, 2022, 08:26:32 pm »
@SMcNeill Thank you for the working example. Very helpful. I appreciate your time and effort on it. The info you put in the Excel file example gave me a good laugh.  You have humor! 

This gets me well on my way to were I need to go.  Interestingly, I found that the numerical values (like the number 50) end up under \xl\worksheets\sheet1.xml (in this case, because the one sheet in the file is named "sheet1") rather than in xl\sharedSrtings.xml. As an aside: I also found that the XLSX files saved by Excel and those saved by LibreOffice Calc differ somewhat in what extra stuff is included in sharedStrings.xml.  It will take me some studying and testing to figure out how the format works and were the items go.  Again, your working example has given me an excellent starting point and I am very grateful.

Thanks also to everyone else who has chimed in. I appreciate any additional pointers and input anyone may have.

LM

Offline SMcNeill

  • QB64 Developer
  • Forum Resident
  • Posts: 3972
    • Steve’s QB64 Archive Forum
Re: Question regarding interacting with Excel files
« Reply #16 on: April 08, 2022, 08:44:17 pm »
Happy to help get you started, though I'm afraid that's about all I can do for you.  I just don't use Excel enough to have any real idea of it's syntax structure beyond the very basics which I shared above. 😉

You have my best wishes for the rest of the project!  👍
https://github.com/SteveMcNeill/Steve64 — A github collection of all things Steve!