issue regarding loading xlsx file in spread grid

Posted by: prajakta1 on 3 August 2017, 5:34 am EST

  • Posted 3 August 2017, 5:34 am EST

    My .xlsx file is not loaded in Farpoint spread by using

    1.Spreadsheet.ImportExcelBook(s,"D:\\sentence_string.txt");

    2. Spreadsheet.GetExcelSheetList(s, null, ref sheetcount, "", ref handle, true); Spreadsheet.ImportExcelSheet(handle, 0);

    3. Spreadsheet.OpenExcel2007File(s, "", -1,0, "D:\\sentence_string.txt" );

    for Farpoint control 8.0 version  where s =filename& spreadsheet is Farpoint spread control name.please help me for loading .xlsx file in farpoint spread 8.0.

     

  • Replied 3 August 2017, 5:34 am EST

    Prajakta,

    ImportExcelBook method only works for Excel 2003(.xls) file format. In order to import an excel 2007(.xlsx) file you must use OpenExcel2007File method. If you wish to open the entire workbook use -1 as sheet index. For example this code should open the .xlsx file for you.

    <span style="font-family:Tahoma, Arial, Helvetica;font-size:10pt;">Spreadsheet.OpenExcel2007File(s, "", -1,-1, "D:\\sentence_string.txt" );</span> 

    If you still face any issues opening the .xlsx file please let me know , if possible provide me the .xlsx file to further test it at my end.

     

    Thanks, 

Need extra support?

Upgrade your support plan and get personal unlimited phone support with our customer engagement team

Learn More

Forum Channels