creating a csv spreadsheet and formatting it via another program

[Mark A]

I have a set of Linux korn shell and perl scripts (don't worry if you don't
know what those are) that create a csv file that is automatically emailed
from a Linux server to end users. I want to apply some simple formatting to
the spreadsheet such as bold, column widths, number precession, right or
left alignment, and word wrap.

I guess that I could create a macro to do the formatting, but is there some
way to have the macro applied automatically to the csv file without the end
user doing anything?

Is there some other way to do this that I am missing?

 

[Pete_UK]

A .csv file is just text, so rather than send that out can't you
import it into Excel, get a macro to do the formatting and save it as
an Excel file, and then send the .xls file out? Or, once you have done
the macro which sets up the formatting, distribute that to your users
so that they can use it at their end.

Hope this helps.

Pete

 

[Mark A]

A .csv file is just text, so rather than send that out can't you
import it into Excel, get a macro to do the formatting and save it as
an Excel file, and then send the .xls file out? Or, once you have done
the macro which sets up the formatting, distribute that to your users
so that they can use it at their end.

Hope this helps.

Pete

Yes, I could do the formatting, but I need to completely automate the
process.

Giving them the macro might be OK if it could be automatically applied to
the csv file, but there are too many different spreadsheets for them to know
which macro goes with which csv file, and again, I would like completely
automate it.