Welcome, Guest. Please login or register.
November 01, 2014, 10:40:21 AM
Home Help Search Login Register
News: Back to Qbasicnews.com | QB Online Help | FAQ | Chat | All Basic Code | QB Knowledge Base

Qbasicnews.com  |  QBasic  |  QB Discussion & Programming Help  |  Topic: Converting excel to qbasic « previous next »
Pages: [1] Print
Author Topic: Converting excel to qbasic  (Read 3345 times)
DJTREKBIKER
New Member

Posts: 1



Converting excel to qbasic
« on: June 03, 2009, 04:32:12 PM »

Hi All
I have been causually trying to convert excel spreadsheets to qbasic .dat files for some time now and have had no luck.  I can convert a qbasic .dat files to excel but can't figure out how to get them back again.
Can anyone help with this?
Dan
Logged
Ninkazu
Been there, done that
*****
Posts: 1169



WWW
Re: Converting excel to qbasic
« Reply #1 on: June 04, 2009, 09:29:56 AM »

xls or csv? CSV is pretty easy since it's just comma-separated for different columns with new lines to go to the next row, but xls is a lot more complex. Here you can find format details for different versions of the format http://www.wotsit.org/list.asp?al=X
Logged

am an asshole. Get used to it.
Clippy
Member
*
Posts: 84



Re: Converting excel to qbasic
« Reply #2 on: June 04, 2009, 03:19:07 PM »

QB can use WRITE to created Comma Separated Variable files. The row count of variables is fixed. Are the files you are accessing CSV files? You should be able to open the files in Notepad or Wordpad to check them.

If all that you see are weird symbols, then the file may be binary format.
Logged

Pages: [1] Print 
Qbasicnews.com  |  QBasic  |  QB Discussion & Programming Help  |  Topic: Converting excel to qbasic « previous next »
Jump to:  


Login with username, password and session length

Powered by MySQL Powered by PHP Powered by SMF 1.1.19 | SMF © 2013, Simple Machines
SMF Theme © Gaia
Valid XHTML 1.0! Valid CSS!