I am trying to create a program where user can input data in certain excel cells using user interface on internet....the programming is on perl and server is unix
But when i parse data into excel the formatting of sheets is turned to default and all macro coding removed.
What to do...Please Help:confused:
These are limitations of the modules you're using combined with the problems of using a proprietary format.
can u explain which module to use and how???
though i got by google search use Win32::OLE but not able grasp it..
im new with perl please explain.......
And that is why.
Win32::OLE only works on windows AFAIK.
You may have to find a way to solve this which does not involve resaving excel macros. Could you generate a new excel file instead of editing an old one?