Exporting to an Excel file

[Manoj Chaurasia]

Hi,

 

I've tried exporting data from Spotfire to an Excel file. Spotfire created a simple table listing the data that are in my database.

 

Question is, is Spotfire capable of exporting a cross table to an excel file Because that is what I need. I need to create, for example a cross table through Spotfie, then I shall export the created table to an excel file.

 

Regards,

Ben

[Manoj Chaurasia]

Hi Chris,

 

Is there an even easier or faster way to do this Would it be possible to tell Spotfire to export my cross table to the excel file directly And if I have formatting in my visualization, will Spotfire be able to give the same format to the exported file

 

Regards,

Ben

[Manoj Chaurasia]

Hi Ben and Chris,

 

Actually I have the same query...

 

Is it possible to have an action to do this job of exporting

Like a button or something

[Manoj Chaurasia]

Hi Manoj,

 

Thanks for the script and the file, though when I have tried the file the export button is inactive and when I hover my mouse to it a note says that "The script is not trusted". I am new with using scripts with Spotfire I also need help on that on where can I add scripts and how to do it.

 

Regards,

Ben

[Manoj Chaurasia]

Hi Ben,

 

You have to do the following things at your end to make the Script trusted:-

 

 

Edit the text area by right click on the the Scipt button.

Select the Button & Right Click & select the "Edit Control" Option.

Now a new window will pop- up at your screen. Select the Script & click on Edit button.

Now a new window will pop up then simply click on "OK button" without doing anything.

 

 

Now you can see that the button is activated) & it is ready to use.

 

Regards

Manoj Singh

[Manoj Chaurasia]

Hi Manoj,

 

Another problem here, when I've tried to do what you told me on the window where I have to select the script under the Image option it says:

 

To use Script action controls you need to make sure that:

- You are a part of a group with the license Author Scripts (TIBCO Spotfire Extensions) enabled.

 

If this has something to do about having a licensed Spotfire I guess there it can't be helped I only have the trial version of Spotfire.

 

Regards,

Ben

[Manoj Chaurasia]

Hello Ben,

 

If you want to exceute the Scripts then you should have "Author Scripts" licensed enable.

 

I am not sure how to reslove the problem for the Spotfire trail version but as soon as purchased

 

the licensed one, you would be able to execute it.

 

Regards

Manoj Singh

[Manoj Chaurasia]

Hi Manoj,

 

Thanks for the help. For a follow-up question, does Spotfire has the capability to export data into a multitab/multisheet excel file

 

Regards,

Ben

[Manoj Chaurasia]

Hi Ben,

 

As per my understanding you cannot send the data in Mulitab/Multisheet manner.

 

Regards

Manoj Singh

[Manoj Chaurasia]

Hi Manoj,

 

Thanks. It's been a great help.

 

Regards,

Ben

[christopher sawtelle 2]

What you can do is create the cross table in SF then go to FILE>EXPORT>DATA>EXPORT FROM VISUALIZATION then pick the visualization if more than one and select data for all items. This will export the data as a text file that can then be imported to excel.

[Manoj Chaurasia]

Hi Ben,

 

I have created a script & it is working fine at my end. following is the Script:-

 

from Spotfire.Dxp.Data.Export import DataWriterTypeIdentifiers

from System.IO import File

writer = Document.Data.CreateDataWriter(DataWriterTypeIdentifiers.ExcelXlsDataWriter)

filtering = Document.ActiveFilteringSelectionReference.GetSelection(table).AsIndexSet()

stream = File.OpenWrite("C:\SpotfireExport.xls")

names = []

for col in table.Columns:

names.append(col.Name)

writer.Write(stream, table, filtering, names)

stream.Close()

 

& also use Name of Script Parameter- table,Type- Data table & Select data table- name of your data table.

 

Regards

Manoj Singh

[Richard Lake 4]

I'm wondering if this is still the case now that it is 2017  Looking to export a cross table but need to apply about 50 different filtering schemes to it and would like those 50 results within 50 different excel worksheets.

[Rupak Kumar]

Hi Manoj,

 

Did you gte any solution to export multiple visualizations as seperate worksheets in excel

 

We need the same funcitonality.

 

Regards,

 

Rupak

[RKs Rks]

Hi, Is there a way to rename the excel sheet name

[IVishesh Amarpuri]

Hi, I am also having the similar problem. Did you find any solution. Please share. It would be very useful. Thanks

[Hung Huynh]

I tried saving it as a xlsx file and my file is corrupted. However my file is fine if I save it as a xls file. How can I fix this

[Hung Huynh]

I tried saving it as a xlsx file and my file is corrupted. However, my file is fine if I save it as a xls file. How can Ifix this

[Wee Loon Goh]

Hi,

May I know how to extract the table into excel xlsx/xlswith follow the sequence the column in Spotfire instead of auto sorting A-Z base on the column header automatically

 

Thanks in Advance