Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel Macro
Hi All,
I am new to writing excel macros. I need to basically transfer the data which is generated in a table format using perl script on my linux machine to windows and use the data in the table to create a bar chart in excel. Can somebody please give me some ways how this can be achieved. Thanks for your time. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Help with Excel Macro
I did something similar once. Had to first learn just enough Perl to get it
done as my first step. I took on-line input into an Access database and used Perl to pull it out and provide bar charts in an HTML page. For those people that wanted the 'raw data' to work with in something like Excel, I took the data and wrote it to a comma separate values format ASCII file. People then downloaded the .csv file and opened it in Excel and did what they wanted with it. If you write your data out to an ASCII file using commas to separate the values on each row, then Excel will be able to read the file and display the data in separate cells. Then you can use Excel to create the chart. I don't know that you can control Excel directly from Perl (especially from over in Linux), so if that is part of your request, I cannot help you there. Lets say your table looked like this: 5 7 22 13 27 you would want the contents of your myBarData.csv file (just to give it a name) to look like this 5,7,22,13,27 I believe a newline at the end will terminate it properly. "Deepu" wrote: Hi All, I am new to writing excel macros. I need to basically transfer the data which is generated in a table format using perl script on my linux machine to windows and use the data in the table to create a bar chart in excel. Can somebody please give me some ways how this can be achieved. Thanks for your time. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel application.quit in macro problem | New Users to Excel | |||
How to stop Excel remembering/loading macro from previously opened Workbook | Excel Discussion (Misc queries) | |||
Macro Help In Excel | Excel Discussion (Misc queries) | |||
Closing File Error | Excel Discussion (Misc queries) | |||
passing arguments from an excel macro to a word macro | Excel Discussion (Misc queries) |