how can I import my datas in excel to mathematica and then do calculations on them?

[deniz10]

Dear members, i've just signed up to this group to get your ideas about
my problem, First of all i'm a mathematic engineering student in
university and this is about my graduation project.
To summarize,
i have over 3650 datas in my excel files, they are datas of each day
past 10 years, i should import this to mathematica to do some
calculations, i 'll find increment or decrement percentage of each day
according to the next day, i almost need to have 3649 calculations,
can't do it without mathematica :) but i can't even import those datas
?
does any of you have any kind of idea, i'll gratefull if you help me.

[Bill Rowe]

Post by deniz10
i have over 3650 datas in my excel files, they are datas of each day
past 10 years, i should import this to mathematica to do some
calculations, i 'll find increment or decrement percentage of each day
according to the next day, i almost need to have 3649 calculations,
can't do it without mathematica :) but i can't even import those
datas? does any of you have any kind of idea,

When asking for help, it is a very good idea to post what you've tried. That makes it much easier to see what the problem is and for those that would offer help to make more focused suggestions.

The current version of Mathematica can read and write Excel files. To import data from an Excel file do

Import[filename, "XLS"]

to write data out to an Excel file do

Export[ilename, data, "XLS"]

For more information use the help browser to read the documentation for Import and Export.
--
To reply via email subtract one hundred and four

[Onkar Singh]

I am not sure how familiar are you with Mathematica. Please check the
Help Browser for Import[] function.
Import["file", "format"] should work. In your case "CSV" or "XLS" might
be relevant. The "file" argument requires the full path of the path.

Let me know if you have any problems (please provide details about what
exactly you are doing and specific error messages).

- Onkar

Post by deniz10
Dear members, i've just signed up to this group to get your ideas about
my problem, First of all i'm a mathematic engineering student in
university and this is about my graduation project.
To summarize,
i have over 3650 datas in my excel files, they are datas of each day
past 10 years, i should import this to mathematica to do some
calculations, i 'll find increment or decrement percentage of each day
according to the next day, i almost need to have 3649 calculations,
can't do it without mathematica :) but i can't even import those datas
?
does any of you have any kind of idea, i'll gratefull if you help me.

[Steven Shippee]

Please describe your excel spreadsheet in a bit more detail.

For example, is it a workbook, with multiple sheets (and formulae)?

Or is it all one worksheet?

Steven Shippee

slshippee at comcast dot net

Post by deniz10
Dear members, i've just signed up to this group to get your ideas about
my problem, First of all i'm a mathematic engineering student in
university and this is about my graduation project.
To summarize,
i have over 3650 datas in my excel files, they are datas of each day
past 10 years, i should import this to mathematica to do some
calculations, i 'll find increment or decrement percentage of each day
according to the next day, i almost need to have 3649 calculations,
can't do it without mathematica :) but i can't even import those datas
?
does any of you have any kind of idea, i'll gratefull if you help me.

[David Annetts]

Hi Deniz,

Post by deniz10
Dear members, i've just signed up to this group to get your
ideas about my problem, First of all i'm a mathematic
engineering student in university and this is about my
graduation project.
To summarize,
i have over 3650 datas in my excel files, they are datas of
each day past 10 years, i should import this to mathematica
to do some calculations, i 'll find increment or decrement
percentage of each day according to the next day, i almost
need to have 3649 calculations, can't do it without
mathematica :) but i can't even import those datas ?
does any of you have any kind of idea, i'll gratefull if you help me.

You'll need to give a few more details as to how your data are set up ....

How are the data organised? As 3650 Excel spreadsheets? In a single
spreadsheet as multiple pages? Some other combination?

You might also want to investigate consolidating data within a single
spreadsheet to minimise the number of files you have to deal with, but the
bottom line is that Mathematica (5.2) can directly import data from Excel
and it can deal with multiple files as a matter of course.

If you have an earlier version, then you'll probably have to write data to
text files & read them directly (either Import[] or ReadList[] depending on
how old your copy of Mathematica is).

Failing that, post some code and and / or data.

Regards,

Dave.