How to data bind in wijmo using array

How to data bind in wijmo using array

Posted by: syed.mahmud on 24 April 2023, 8:46 pm EST

• 

  syed.mahmud

  • Post Options:
  • Link
    Copy

  Posted 24 April 2023, 8:46 pm EST

  I’m currently working on a project where I need to pass an array of data that will configure various settings in an Excel spreadsheet. I’m using Spreadsheet Gear with a .NET web API.

  The idea is to have all the settings configured through this one array of data. This includes merged cells, cell styles, and any other configuration options that can be set in Excel.

  I was wondering if anyone has any experience with this or could provide some guidance on how to approach it. It would be really helpful to have all the settings in one place for easy configuration.

  Thanks in advance for any help you can provide!

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 5:04 pm EST

  Hello,

  Yes, you can achieve this in FlexSheet control. You can iterate over each cell and use the data array with setCellData(), applyCellStyle(), and mergeRange() methods to set data, apply styles and apply merging on cells respectively.

  Using the above FlexSheet methods you can set the sheet data, styles, and merging initially after you get the data from the API. In case you face any issues please share the data array along with a small sample replicating the issue. We would be happy to help you out.

  Regards

• 

  syed.mahmud

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 5:17 pm EST

  Hi , i did what you said . But in case of very large data it is not as fast as wijmo’s built in data binding .

• 

  sonu.pandey

  

  • Post Options:
  • Link
    Copy

  Posted 25 April 2023, 8:24 pm EST

  Hello,

  I request you to please share a small sample with the dummy data replicating your issue so that we can further investigate the issue at our end to find the root cause.

  In case you cannot share it on this public forum then please create a ticket for the same under the my support section in your account. I look forward to hearing back from you.

  Regards