Digital Workshop

Welcome to the Digital Workshop Message Boards
It is currently December 30th, 2024, 8:51 am

All times are UTC [ DST ]




Post new topic Reply to topic  [ 5 posts ] 
Author Message
 Post subject: xlsx instead of csv
PostPosted: May 12th, 2019, 10:29 am 
Offline

Joined: May 16th, 2008, 4:50 pm
Posts: 368
Location: Berghem The Netherlands
Opus: Opus Pro 9.75
OS: Windows 10
System: `HP
Is it possible to use .xslx files in Opus instead of CSV.
I have to use .xlsx files in real time. CSV files is no problem but in this case i don't have time to convert them.

Kind Regards,
Ad Mulders

_________________
Opus Pro v9.75
Windows 10 on HP EliteBook i7
http://www.csnmedia.nl


For this message Ad Mulders has been thanked by : mackavi


Top
 Profile Visit website  
 
 Post subject: Re: xlsx instead of csv
PostPosted: May 12th, 2019, 8:56 pm 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
If it's ODBC then as long as a driver is installed, you can connect. If you're simply trying to save data using Opus' file functions - then no. XLSX is a proprietary format that contains document specific data. CSV is just plain text with commas.

</mack>

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


For this message mackavi has been thanked by : Ad Mulders


Top
 Profile Visit website  
 
 Post subject: Re: xlsx instead of csv
PostPosted: May 15th, 2019, 7:34 pm 
Offline

Joined: May 16th, 2008, 4:50 pm
Posts: 368
Location: Berghem The Netherlands
Opus: Opus Pro 9.75
OS: Windows 10
System: `HP
Hi Mack,
Do you have an example file how i can make it myself?
Hope you can help me

Kind Regards,
Ad Mulders

_________________
Opus Pro v9.75
Windows 10 on HP EliteBook i7
http://www.csnmedia.nl


For this message Ad Mulders has been thanked by : mackavi


Top
 Profile Visit website  
 
 Post subject: Re: xlsx instead of csv
PostPosted: May 16th, 2019, 5:11 pm 
Offline
Godlike
Godlike
User avatar

Joined: March 21st, 2007, 10:44 am
Posts: 3188
Location: UK
Opus: Evolution
If you mean an example of how to create an XLSX file, then I'm afraid that's not possible using Opus.

The contents of such files are machine readable only. Meaning that unlike, plain text, HTML or XML - the contents make no sense to a human reader.

I've never done any research on the matter, but if I had to pick somewhere to start because my project had to have the ability to write to XLSX, I would look to see if a DLL existed or could be written.

</mack>

_________________
When you have explored all avenues of possibilities, what ever remains, how ever improbable, must be the answer.

Interactive Solutions for Business & Education
Learn Anywhere. Learn Anytime.

www.interaktiv.co.uk
+44 (0) 1395 548057


Top
 Profile Visit website  
 
 Post subject: Re: xlsx instead of csv
PostPosted: May 16th, 2019, 6:22 pm 
Offline

Joined: May 16th, 2008, 4:50 pm
Posts: 368
Location: Berghem The Netherlands
Opus: Opus Pro 9.75
OS: Windows 10
System: `HP
Thanks Mack for the clear answer.
I have to read a file from a server and now i have an idea to automate the conversion
from xlsx to csv, by every update.
CSV files work great so in i can automate it the problem is solved.

Ad

_________________
Opus Pro v9.75
Windows 10 on HP EliteBook i7
http://www.csnmedia.nl


For this message Ad Mulders has been thanked by : mackavi


Top
 Profile Visit website  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 5 posts ] 

All times are UTC [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


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
You cannot post attachments in this forum

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