Spreadsheet Integration Issue

[Christiaan Collier]

Hi Team,

We have an official Enterprise license and we are trying to integrate the Spreadsheet control in our application.

We are loading files from Azure storage and we also trying to save the spreadsheet on the Azure Blob storage account.

Please find the attached zip file which contains document for the list of issues we are facing.

Attachment: CC__bb13233.zip

[Madhan Venkateshan]

Hi Christiaan Collier, 

 

Good day to you. 

 

Query #1: We are not able to find string stream from spreadsheet 

 

You can use ‘SaveAs’ method of XlsIO IWorkbook to get the stream from spreadsheet, please refer the below code snippets and sample link. 

 

HomeController.cs           

public string SaveToServer(SaveSettings saveSettings) 

        { 

            ExcelEngine excelEngine = new ExcelEngine(); 

            IApplication application = excelEngine.Excel; 

            try 

            { 

                // Convert Spreadsheet data as Stream 

                Stream fileStream = Workbook.Save<Stream>(saveSettings); 

                IWorkbook workbook = application.Workbooks.Open(fileStream); 

                MemoryStream outputStream = new MemoryStream(); 

                workbook.SaveAs(outputStream); 

                // Use the 'outputStream' to store it in azure blob 

                return "Spreadsheet saved successfully."; 

            } 

            catch (Exception ex) 

            { 

                // exception code comes here 

                return "Failure"; 

            } 

        } 

 

Sample link: https://www.syncfusion.com/downloads/support/forum/156356/ze/SSSaveAsStream450031753 

 

Query #2: Column Header is not displaying (which CSS and JS we need to import for this ) 

 

You do not need any css and js to import for this. We have checked this issue in our end, we are not able to reproduce it in our end, could please reproduce your issue in the above sample or share any issue reproducible sample to check the issue in our end. 

 

Query #3: For Search we use “AllowFindAndReplace(true)” but search is not working. Which javascript function we need to overwrite to search in spreadsheet for all occurrences? 

 

Could you please confirm whether you need to search using ‘find’ functional like in the below screenshot and also please confirm whether you need to use ‘find’ after opening an excel file into the spreadsheet, in this case you are facing this issue. 

 

 

 

Regards, 

Madhan V