1
vote
2answers
74 views

Problem with exporting lists to Excel

When I use the form Export["file", list, "Table"] to export a list to Excel, I get columns of lists. I want my Excel sheet to have each list element in a separate ...
2
votes
1answer
122 views

Export results to excel

I have the following problem solved in Mathematica ...
1
vote
1answer
87 views

Naming Excel Sheets automatically

After performing some calculations with excel sheets I end with a tridimensional matrix a to be export to a .xlsx format and a vector q that contains the name of all the sheets (so $Length[q] = ...
1
vote
0answers
205 views

How to Export Data from Mathematica into Excel specific cell

for import,we can do like this Import["XXX.xlsx", {"Data",1,2,3}],Mathematica will get the cell {2,3} of the "sheet1" in "XXX.xlsx". But if we want to export data from Mathematica to one Excel ...
7
votes
1answer
179 views

Error while exporting to Excel with named sheets

Using Mathematica v9.0.1 This example is from the docs: ...
6
votes
1answer
861 views

Possible to export Excel formulas?

I would like to export an .XLS file complete with data and formulas. Is this possible using Export? For example, here is data and a formula :- I can import ...
0
votes
1answer
260 views

Exporting B Spline Function to Excel

I am trying to export the data from a B Spline Function to a table in excel. I have tried exporting as many different file types (.xls, .txt, .dat), but all of them show up in excel as all of the ...
2
votes
0answers
166 views

Exporting Specific Cells of Many Workbooks into One using Mathematica

I currently have a large number of detailed files from which I would like to extract certain cells' information to make an Archive spreadsheet. There are approximately 9 parameters of each ...
-4
votes
1answer
266 views

Export plot to Excel

Very new to Mathematica. Used the code to solve for the response of a system of spring mass dampers but would like to export the data to Excel. ...
5
votes
2answers
885 views

Exporting a .xlsx file with about 500 columns

When I want to Export["text.xlsx", data] where data is a matrix with 500 columns and 10000 rows, I get the error message: ...
3
votes
1answer
256 views

How do I format an Exported plot to Excel?

I have the following piece of code: ...
-4
votes
1answer
282 views

How to export data to specific rows and columns in XL file from Mathematica?

I have an XL File with data like : {{1,2,3},{4,5,6},{7,8,9}} That XL file name as ...
9
votes
2answers
713 views

Exporting data from Excel into Mathematica using clipboard

I know that it's possible to import Excel data into Mathematica using the Import command, as we can see in this post. But some times, I need just to do some fast ...
2
votes
1answer
1k views

How to export data from excel specific cells into mathematica?

How to export data from excel specific cells into Mathematica? Given that the spreadsheet tab is named XYZ and that I have several cells at various locations in the same column in Excel that I want to ...
11
votes
1answer
800 views

Export data to Excel with adjusted column size

I'm trying to export some data with formats into Excel. It works ok, but the columns size get not properly adjusted. I don't want to use some complicated solution based on this example. In my tests, ...
1
vote
1answer
383 views

Export to Excel gives error for large lists

This is my data mwedata.dat I do this: ...
8
votes
1answer
1k views
4
votes
1answer
1k views

Export Table from Mathematica into specific cells Excel

How can I export a table to Excel - to specific cells, e.g. D1-E2? Background: I want to compare results, and it's easier to have the results on one spreadsheet. I'm using Mathematica 6. This is my ...
7
votes
2answers
790 views

Is it possible to export a graph as graphic to Excel?

It is straightforward to export lists to Excel with Export. Can I export a graphic image, too? This does not work: ...
8
votes
1answer
573 views

Why does Export drop namespace prefixes in the exported XML file?

I am trying to generate an Excel-compatible XML file from Mathematica. First, I created a test XML file by saving a Microsoft Excel workbook as "XML Table". Then I ...
11
votes
2answers
1k views

How to dynamically name and date a file for export?

I have various functions that export Excel and text files, and need to have them named with a name based on the content of some variables in the function and the time and date. How can this be done ...