Real Software Forums

The forum for Real Studio and other Real Software products.
[ REAL Software Website | Board Index ]
It is currently Thu Oct 19, 2017 6:31 pm
xojo

All times are UTC - 5 hours




Post new topic Reply to topic  [ 6 posts ] 
Author Message
 Post subject: Parse Excel Spread Sheet?
PostPosted: Thu May 23, 2013 7:51 pm 
Offline
User avatar

Joined: Wed Jul 07, 2010 2:55 pm
Posts: 720
Location: University Of Calgary, Faculty Of Medicine
I want to read an excel spread sheet and populate a listbox with the columns in that spread sheet.
Any comment on how this might be done?
I know I can put a spread sheet on a window, but this is for a web application and I'm not sure if the platform is going to be windows or linux...

_________________
If at first you don't succeed... Try REALBasic and if that doesn't work try Xojo.


Top
 Profile  
Reply with quote  
 Post subject: Re: Parse Excel Spread Sheet?
PostPosted: Fri May 24, 2013 4:33 am 
Offline
User avatar

Joined: Wed May 10, 2006 2:42 pm
Posts: 2985
Location: Germany
Our MBS XL Plugin does that:
http://www.monkeybreadsoftware.de/realb ... -xls.shtml

Greetings
Christian

_________________
See you in Orlando, Florida for Real World 2013
More details and registration here:
http://www.realsoftware.com/community/realworld.php


Top
 Profile  
Reply with quote  
 Post subject: Re: Parse Excel Spread Sheet?
PostPosted: Fri May 24, 2013 8:03 am 
Offline
User avatar

Joined: Tue Jan 04, 2011 3:02 am
Posts: 1236
Location: Jönköping, Sweden
If you want a challenge and not a Plug-in you could parse the XLSX yourself.
It's basically a zip archive containing a bunch of xml files for you to parse!
Replace the file ending with .zip, unzip it and examine the contents.
It's not easy as the contents is spread in multiple XML files ;-)

PS. MBS is the quickest solution.

_________________
Image http://www.linkedin.com/in/albinkiland
Dev. iMac 27" + 2x22" LG (2.8GHz Intel Core i7, 12GB RAM, 120GB SSD) OS X 10.8
Xojo Pro 2013r1


Last edited by Akiland on Fri May 24, 2013 8:18 am, edited 2 times in total.

Top
 Profile  
Reply with quote  
 Post subject: Re: Parse Excel Spread Sheet?
PostPosted: Fri May 24, 2013 8:16 am 
Offline
User avatar

Joined: Wed May 10, 2006 2:42 pm
Posts: 2985
Location: Germany
And the MBS Plugin works with older xls files and newer xlsx files.

Greetings
Christian

_________________
See you in Orlando, Florida for Real World 2013
More details and registration here:
http://www.realsoftware.com/community/realworld.php


Top
 Profile  
Reply with quote  
 Post subject: Re: Parse Excel Spread Sheet?
PostPosted: Fri May 24, 2013 4:54 pm 
Offline

Joined: Thu May 13, 2010 7:27 pm
Posts: 341
MonkeybreadSoftware wrote:
Our MBS XL Plugin does that:
http://www.monkeybreadsoftware.de/realb ... -xls.shtml

Greetings
Christian


Sweet I never realized that!! I have the Complete MBS pack and I have yet to use all of the Plugins.


Top
 Profile  
Reply with quote  
 Post subject: Re: Parse Excel Spread Sheet?
PostPosted: Fri May 24, 2013 5:01 pm 
Offline
User avatar

Joined: Wed May 10, 2006 2:42 pm
Posts: 2985
Location: Germany
Be aware that libXL is an extra purchase as you read on our website.

Greetings
Christian

_________________
See you in Orlando, Florida for Real World 2013
More details and registration here:
http://www.realsoftware.com/community/realworld.php


Top
 Profile  
Reply with quote  
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 6 posts ] 

All times are UTC - 5 hours


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum

Search for:
Jump to:  
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group