Linked Questions

266
votes
12answers
45k views

Where can I find examples of good Mathematica programming practice?

I consider myself a pretty good Mathematica programmer, but I'm always looking out for ways to either improve my way of doing things in Mathematica, or to see if there's something nifty that I haven't ...
21
votes
3answers
753 views

Suitability of Mathematica as platform for engineering calculations and programs

I am considering using Mathematica with Wolfram Workbench as a standard platform for calculations and programs in a large engineering department. I am looking for a solution that would provide better ...
13
votes
4answers
2k views

Cut and paste data from a spreadsheet

I have a set of data points in two columns in a spreadsheet (OpenOffice Calc): I would like to get these into Mathematica in this format: ...
9
votes
2answers
832 views

How to write data from Mathematica to an existing formated Excel file?

I have a sheet in an Excel file already formated: different colors, fonts, columns width and cells styles. I want to fill-out values from Mathematica into specific cells of that sheets, or use that ...
6
votes
2answers
630 views

How can I open an Excel file and modify it in Mathematica?

I wanted to ask how can I view an Excel file from a Mathematica notebook and modify it. I have seen a similar question, Open Excel file with Mathematica, but the answer involves .NET. Is there any ...
7
votes
1answer
915 views
11
votes
1answer
399 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, ...
7
votes
1answer
291 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 ...
2
votes
1answer
147 views

Using NetLink to Import Excel File

I can import an Excel file into Mathematica easily: But when I try from .Net it fails: These are the commands and errors I am getting: ...
2
votes
0answers
230 views

Retrieving Data from Excel Using NETLink / Pulling data using RTD Link

Reference: I've looked at the posting Open excel file with Mathematica. My intention is to be able to use Excel's RTD capability in order to pull market data into Mathematica. To my knowledge, this ...