I'm able to copy HTML file content to a XLS file using this method[File.Copy()]properly. But while i'm copying HTML file content to a XLSX file, i observed its able to copy all data properly ,but its making this XLSX file curropted. SO its not able open in EXCEL 2007.Getting error as its a curropted file.
But if we manualy change the foramt of the same created XLSX file to XLS , then its able to open in OFFICE 2007(with a formal warning message as its a lower version formated).
I came to know an .xlsx file is opened strictly as a ZIP package used by 2007 office applications.So i don't feel there is any easy way to create a good XLSX file from a HTML file in C#.
So kindly please guide me if any different way to create this XLSX file.