Save tables in excel format

Discussions about tabulating data in the designer or in batch mode
Post Reply
AriSilva
Posts: 601
Joined: July 22nd, 2016, 3:55 pm

Save tables in excel format

Post by AriSilva »

Hi folks,
Is there a way to save the results of a table directly to an excel format (.xlsx), like in the dataviewer tool?
Now the "only" way I can do it is to save as .html and then drag and drop the file into the excel window.
Best
Ari
Best
Ari
sherrell
Posts: 400
Joined: April 2nd, 2014, 9:16 pm
Location: Washington, DC

Re: Save tables in excel format

Post by sherrell »

Hi Ari,

Unfortunately no. The most you can do is c&p each table from cspro's tab app and into excel. Tedious when many tables have been generated. And unfortunately our next priority is getting CSPro working for CAWI, so any updates to xtabs will continue to slide for now. Sorry.

Sherrell
Gregory Martin
Posts: 1803
Joined: December 5th, 2011, 11:27 pm
Location: Washington, DC

Re: Save tables in excel format

Post by Gregory Martin »

This may not help you much, but you can export the first table in a .tbw file to .html from the command line:

"C:\Program Files (x86)\CSPro 8.0\TblView.exe" input.tbw /EXPT /HTML output.html

On my machine, I can open this file using:

"C:\Program Files\Microsoft Office\root\Office16\EXCEL.EXE" output.html

This isn't a perfect solution, but you may be able to simplify whatever you're trying to do with these tricks.
Post Reply