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
Save tables in excel format
Re: Save tables in excel format
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
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
-
- Posts: 1876
- Joined: December 5th, 2011, 11:27 pm
- Location: Washington, DC
Re: Save tables in excel format
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.
"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.