Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
AppendFromXlsx code and text format in Excel
Message
From
31/01/2020 11:03:20
 
 
To
31/01/2020 10:34:32
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01672618
Message ID:
01672866
Views:
53
Likes (1)
>Indeed, these are the inline strings, but I never found them to be used, so I ignored them. Thus I tried to maintain the code as simply as possible.
I read about them in Microsoft's documentation, when I create the first versions.

I too have found that Excel does not seem to use this. However, other tools might possibly use this; in particular spreadsheets created from Java POI Spreadsheet class could use this to create large spreadsheets (the POI class could run out of heap space if trying to create a large spreadsheet). My VFPx class also uses this to be able to create a spreadsheet very fast so as not to create the strings.xml file for output of tables or grids.

Greg, you've done a terrific job.
Obviously your intention was to create a competitor for MSOffice, or, at least, OpenOffice.

My goal was much humbler: to create a tool that expand somehow VFP's commands like APPEND FROM, COPY TO or IMPORT, because these VFP commands don't accept documents created by MSOffice 2007+, or OpenOffice, respectively can't create such documents.

So, first I made these functions and classes for my own need, and simply I offered them to the community.
I began with Excel documents, then I saw that Word documents are not very different, so I added new tools.
If you remember, at this point, Cesar Chalom asked me for a tool to create PowerPoint documents, and I found this challenge extremely entertaining.
In the end, I made the corresponding tools for OpenOffice documents, as well.

At some point you contacted me and presented your intention to develop these tools into an exhaustive class, and finally you've made an excellent work, a superb tool. I congratulate you, and I'm proud to be an inspiration for you.

But, like I said, I only need small and easy to use tools. The sources are available, and anyone can improve them, like Naomi already did, or like I've done with Alexander Golovlev's FastXtab :-)
Previous
Reply
Map
View

Click here to load this message in the networking platform