For questions about importing from or exporting to Microsoft Excel sheets, and interfacing to Microsoft Excel using COM or other methods.
6
votes
0answers
190 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, ...
6
votes
0answers
341 views
5
votes
0answers
213 views
Is it possible to construct a function to make a poor man's Mathematica database?
I have a function that is set up to write to a database with 10-20 standard variables with 10 fields each, but the application is going to a place where database access is not available. Can ...
1
vote
0answers
50 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 ...
0
votes
0answers
105 views
Export data from Excel not working for vlookup data
I have a cell in Excel in which this value is obtained by using the vlookup function (=vlookup(n,table range, column number) ). ...
