Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing an Excel Spreadsheet via a program's output
Hi folks,
I'm new to this forum, but hopefully someone has an idea on the below situation. First of all, I am not a Windows programmer (VB, VBScript, Visual C++, ASP, etc). I have written several programs using Unix shell scripting (bash, sed, grep, etc) that are not really anything more than "find a string and output that string to an outfile". Over the iterations, I have upgraded it to write out in a tab delimited format and even included a cell that totals the contents of column B (included: =SUM(B1..B300) in my last cell. All along, I have just written the file as tab delimited plain text with a .xls extension. I am sensing an upcoming need to explore more of Excel's functions, like bolding text, writing to different worksheets in the same workbook, etc. Does anyone know of a resource that explains Excel file formatting to the degree that I can produce an Excel file as the output to a simple program? Many thanks, Blake Thompson |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing an Excel Spreadsheet via a program's output
Try the Help in excel, F1 key or the menu. Also do some searches on google.
"Blake" wrote in message om... Hi folks, I'm new to this forum, but hopefully someone has an idea on the below situation. First of all, I am not a Windows programmer (VB, VBScript, Visual C++, ASP, etc). I have written several programs using Unix shell scripting (bash, sed, grep, etc) that are not really anything more than "find a string and output that string to an outfile". Over the iterations, I have upgraded it to write out in a tab delimited format and even included a cell that totals the contents of column B (included: =SUM(B1..B300) in my last cell. All along, I have just written the file as tab delimited plain text with a .xls extension. I am sensing an upcoming need to explore more of Excel's functions, like bolding text, writing to different worksheets in the same workbook, etc. Does anyone know of a resource that explains Excel file formatting to the degree that I can produce an Excel file as the output to a simple program? Many thanks, Blake Thompson |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing an Excel Spreadsheet via a program's output
Turn on the macro recorder and do the steps manually - turn it off and look
at the recorded code. Macro Recorder: Tools=Macro=Record a New Macro This is inefficient code, but it gives you a basic idea of the syntax need. Read post in this forum. Ask specific questions when you need help. Consult the Knowledge Base http://support.microsoft.com go to Advanced Search. -- Regards, Tom Ogilvy Blake wrote in message om... Hi folks, I'm new to this forum, but hopefully someone has an idea on the below situation. First of all, I am not a Windows programmer (VB, VBScript, Visual C++, ASP, etc). I have written several programs using Unix shell scripting (bash, sed, grep, etc) that are not really anything more than "find a string and output that string to an outfile". Over the iterations, I have upgraded it to write out in a tab delimited format and even included a cell that totals the contents of column B (included: =SUM(B1..B300) in my last cell. All along, I have just written the file as tab delimited plain text with a .xls extension. I am sensing an upcoming need to explore more of Excel's functions, like bolding text, writing to different worksheets in the same workbook, etc. Does anyone know of a resource that explains Excel file formatting to the degree that I can produce an Excel file as the output to a simple program? Many thanks, Blake Thompson |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Writing an Excel Spreadsheet via a program's output
Reverse engineering.... I like it.
Thanks for the hint Tom, I'll try it. Blake "Tom Ogilvy" wrote in message ... Turn on the macro recorder and do the steps manually - turn it off and look at the recorded code. Macro Recorder: Tools=Macro=Record a New Macro This is inefficient code, but it gives you a basic idea of the syntax need. Read post in this forum. Ask specific questions when you need help. Consult the Knowledge Base http://support.microsoft.com go to Advanced Search. -- Regards, Tom Ogilvy Blake wrote in message om... Hi folks, I'm new to this forum, but hopefully someone has an idea on the below situation. First of all, I am not a Windows programmer (VB, VBScript, Visual C++, ASP, etc). I have written several programs using Unix shell scripting (bash, sed, grep, etc) that are not really anything more than "find a string and output that string to an outfile". Over the iterations, I have upgraded it to write out in a tab delimited format and even included a cell that totals the contents of column B (included: =SUM(B1..B300) in my last cell. All along, I have just written the file as tab delimited plain text with a .xls extension. I am sensing an upcoming need to explore more of Excel's functions, like bolding text, writing to different worksheets in the same workbook, etc. Does anyone know of a resource that explains Excel file formatting to the degree that I can produce an Excel file as the output to a simple program? Many thanks, Blake Thompson |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
writing a formula in Excel spreadsheet to track how long data has | Excel Worksheet Functions | |||
Printing same spreadsheet range getting different output | Excel Discussion (Misc queries) | |||
I cant use all the functions in Excel,so the program's useless | Excel Worksheet Functions | |||
How can I output VBA function results (array's for example) to spreadsheet | Excel Worksheet Functions | |||
Writing a macro that will exit a spreadsheet | New Users to Excel |