Thanks for your reponse :)Would not be able to meddle with the Excel file as it would be uploaded by users.
Found a way out for this and sharing it here.Concept is basically converting xls file to csv file.Do note method below is for Windows and requires MS Excel to be installed on server.For solution on Linux platforms, there's a variety of solutions from Googling Linuxconvert xls to csv.The VB script code below can be saved into a .vbs file (ExcelToCSV.vbs)A batch file (ConvertDoc.bat ) can then be created to call the VBS file with the source file location and destination file location as the first and second argument respectively. Example: ConvertDoc.bat C:\temp\test1.xls C:\temp\test1.csv
Then using Miscellaneous/Run External Command to run the batch file, we would obtain a csv file which we can easily manipulate.CheersCliff
@echo offcscript [Path To VBS file]\ExcelToCSV.vbs %1 %2
if WScript.Arguments.Count < 2 Then WScript.Echo "Please specify the source and the destination files. Usage: ExcelToCsv <xls/xlsx source file> <csv destination file>" Wscript.QuitEnd Ifcsv_format = 6Set objFSO = CreateObject("Scripting.FileSystemObject")src_file = objFSO.GetAbsolutePathName(Wscript.Arguments.Item(0))dest_file = objFSO.GetAbsolutePathName(WScript.Arguments.Item(1))Dim oExcelSet oExcel = CreateObject("Excel.Application")Dim oBookSet oBook = oExcel.Workbooks.Open(src_file)oBook.SaveAs dest_file, csv_formatoBook.Close FalseoExcel.Quit
For best results, use the Firefox browser..