covert to excel - Forum

Forum Navigation
You need to log in to create posts and topics.

covert to excel

I want to convert Excel data into this format
It is possible?

"string","string","string","string","string","string",........

hello,

use the commandline tool ssconvert (if you do not want to save your file within Excel into csv, txt etc.)

info ssconvert: http://manpages.ubuntu.com/manpages/bionic/man1/ssconvert.1.html#example

code you need: ssconvert -O 'separator=; format=raw' samples/excel/statfuns.xls statfuns.txt

best regards,

reinier

 

 

Could you give me more tips on how to use it?

Hi,

Download Gnumeric via

https://portableapps.com/apps/office/gnumeric_portable

and install it.

The file ssconvert.exe can be found in a subfolder. In my case:

D:\PortableApps\PortableApps\GnumericPortable\App\Gnumeric\bin

To make it simple, put your Book1.xls in this directory.

Launch the Command Prompt, go to the bin directory and enter the next command

ssconvert -O "separator=$ format=raw" Book1.xls Book1.txt

(I always use a separator that is not used in the Excel-file, e.g. $ or #)

Press return and Book1.txt will be made.

You've only to replace $ with "," in Book1.txt. You can do this with a text processor or
with your VisualNeo application (FileRead etc.).

Yes, you can make your own VisualNeo conversion application using ssconvert.exe (including some dependencies).

Best regards,
Reinier

Deleted user has reacted to this post.
Deleted user

Hi,

My post on the Neobook forum could also be helpful:

http://archive.visualneo.com/viewtopic.php?f=6&t=21686&p=11220703

Best regards,

Reinier