Sorry your browser is not supported!

You are using an outdated browser that does not support modern web technologies, in order to use this site please update to a new browser.

Browsers supported include Chrome, FireFox, Safari, Opera, Internet Explorer 10+ or Microsoft Edge.

DarkBASIC Professional Discussion / MS Excel

Author
Message
Philip
23
Years of Service
User Offline
Joined: 15th Jun 2003
Location: United Kingdom
Posted: 19th Sep 2010 15:04
Link
Hi all

Sorry to ask so many questions of late but I've been away from the community for a couple of years and I'm trying to catch back up with developments.

My current question is has anyone written a plugin or other useful tool to help one open MS Excel files in DBPro? I'm looking for a way of opening Excel files, extracting data and indeed saving data back into an Excel file.

Cheers

Philip

Cheer if you like bears! Cheer if you like jam sandwiches!
"I highly recommend Philip" (Philip)
Back to top
Profile PM Email
IanM
Retired Moderator
23
Years of Service
User Offline
Joined: 11th Sep 2002
Location: In my moon base
Posted: 19th Sep 2010 17:13
Link
The Enhancement pack apparently provides commands for accessing Excel and CSV files - I have no idea how well they work.

For my own use, I added my own File I/O plug-in (provides a comprehensive set of commands/functions for accessing file content), and added an Excel compatible SPLIT CSV STRING command to my string plug-in (all of which works just as well with OpenOffice-calc that I now use).

Utility plug-ins (26-JUL-2010)
I'm applying terms of use that require you to wear a red nose and honk a horn whenever you use the Internet
Back to top
Profile PM Email Website
Back to top

Login to post a reply

Server time is: 2026-07-22 12:41:45
Your offset time is: 2026-07-22 12:41:45