Adding Multiple worksheet in single workbook using multithreading

6 posts, 0 answers
  1. Anupkumar
    Anupkumar avatar
    5 posts
    Member since:
    Aug 2017

    Posted 28 Sep Link to this post

    Hi,

    Can we add multiple worksheet in a single workbook using multithreading? Or can we write single worksheet using multithreading?

  2. Nencho
    Admin
    Nencho avatar
    1645 posts

    Posted 02 Oct Link to this post

    Hello Anupkumar,

    Could you please elaborate a bit more on your question, and especially on the multithreading part? If you attempt to implement the possibility to modify the content of a certain Spreadsheet (its workbook) at the same time, you can achieve this by binding it to WebSockets or SingalR.

    However, this is a not inbuilt functionality of the Spreadsheet. Such feature request is logged in our public uservoice portal and the above suggested implementation is also suggested there:

    http://kendoui-feedback.telerik.com/forums/127393-kendo-ui-feedback/suggestions/13753044-spreadsheet-editing-simultaneously

    Hope this information helps.

    Regards,
    Nencho
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  3. Anupkumar
    Anupkumar avatar
    5 posts
    Member since:
    Aug 2017

    Posted 03 Oct Link to this post

    Hi,

     I am trying to write data to spreadsheet from a data table that has huge number of records. I tried to create multiple worksheet and using multithreading I wanted to write it simultaneously. So my question is can I write multiple worksheet simultaneously using threading and then add these worksheets to single workbook? Is it possible to make instance of worksheet rather than instance of workbook? If I am using different workbook to save the worksheet, able to achieve the multithreading but when using single workbook it is not possible because it goes in shared state.

  4. Nencho
    Admin
    Nencho avatar
    1645 posts

    Posted 04 Oct Link to this post

    Hello Anupkumar,

    Thank you for the clarification. I am afraid, however, that the Spreadsheet does not provide this possibility of multithreading. As you had well observed the shared state permits such operations. In addition, simontanious creation of worksheet and then creating the workbook is also not possible, due to internal classes implementation in the source of the widget.

    Regards,
    Nencho
    Progress Telerik
    Try our brand new, jQuery-free Angular 2 components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
  5. Anupkumar
    Anupkumar avatar
    5 posts
    Member since:
    Aug 2017

    Posted 05 Oct in reply to Nencho Link to this post

    Hi Nencho ,

    I used Task parallel library(TPL) and using Parallel.Invoke method I am able to create different task and able to write multiple worksheets (almost) simultaneously. But the issue is with performance, It is taking around 3 mins for just 20000 rows with 67 columns.

     

    Thanks,

    Anup

  6. Nencho
    Admin
    Nencho avatar
    1645 posts

    Posted 09 Oct Link to this post

    Hello Anupkumar,

    Having in mind the large amount of data that you aim to load in the widget, the operation will inevitably take some time. I can suggest you, however, to enable the batch mode of the spreadsheet, as suggested in the following documentation article:

    https://docs.telerik.com/kendo-ui/api/javascript/spreadsheet/sheet#methods-batch

    sheet.batch(function() {
        for (var i = 0; i < 10; i += 2) {
            sheet.hideColumn(i);
            sheet.hideRow(i);
        }
    }, {
        layout: true,
        recalc: false,
        filter: false
    });


    Regards,
    Nencho
    Progress Telerik
    Try our brand new, jQuery-free Angular components built from ground-up which deliver the business app essential building blocks - a grid component, data visualization (charts) and form elements.
Back to Top