July 16, 2020, 12:15:08 AM *
Welcome, Guest. Please login or register.

Login with username, password and session length
News: Back to Qbasicnews.com | QB Online Help | FAQ | Chat | All Basic Code | QB Knowledge Base
   Home   Help Search Login Register  
Pages: [1]
Author Topic: Converting excel to qbasic  (Read 5962 times)
New Member

Posts: 1

« 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?
Been there, done that
Posts: 1169

« 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

am an asshole. Get used to it.
Posts: 84

« 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.

Pages: [1]
Jump to:  

Powered by MySQL Powered by PHP Powered by SMF 1.1.21 | SMF © 2015, Simple Machines Valid XHTML 1.0! Valid CSS!