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.

Newcomers DBPro Corner / reading in data from spreadsheets??

Author
Message
kozma_11
21
Years of Service
User Offline
Joined: 17th Sep 2003
Location: Scotland
Posted: 26th Sep 2003 13:40
Link
hi all,

I was wondering if anyone knows if it is possible to read in data for arrays from a spreadsheet i.e microsoft excel?? I have DarkBasic, not dark basic pro. Many thanks,

John

El Presidente
Back to top
Profile PM Email
MagiKnight
21
Years of Service
User Offline
Joined: 20th Sep 2003
Location:
Posted: 26th Sep 2003 13:46
Link
Its possible! you would have to knwo what format M$ Excel uses
then use for and next to read what you want to read and store it in to an array.

MMMMMM Low level programmimg...
Back to top
Profile PM Email
BatVink
Moderator
21
Years of Service
User Offline
Joined: 4th Apr 2003
Location: Gods own County, UK
Posted: 26th Sep 2003 14:14 Edited at: 26th Sep 2003 14:15
Link
The best approach is probably to convert your spreadsheet to a CSV file, the format is much easier to handle.

...or even XML, even easier from a parsing perspective.

BatVink (formerly StevieVee)
http://facepaint.me.uk/catalog/default.php
Back to top
Profile PM Email
Back to top

Login to post a reply

Server time is: 2024-09-21 01:10:50
Your offset time is: 2024-09-21 01:10:50