creating a csv spreadsheet and formatting it via another program

  • Thread starter Thread starter Mark A
  • Start date Start date
M

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?
 
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
 
Pete_UK said:
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
Click to expand...

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.
 
Back
Top