Close File menu through API and preloader on file loading

Close File menu through API and preloader on file loading

Posted by: anton.kagakin on 26 March 2025, 3:45 am EST

• 

  anton.kagakin

  • Post Options:
  • Link
    Copy
  • Jump To Answer

  Posted 26 March 2025, 3:45 am EST - Updated 26 March 2025, 3:47 am EST

  I need to implement similar behaviour for file import from FIle menu - to show preloader while file is loading throught api call

  spread.import(file)

  and after load complete - close File menu.

  Since this working like that for default “Import” section, I’m guessing there is a way to make it through spreadjs components and calls

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 27 March 2025, 1:41 am EST - Updated 27 March 2025, 1:47 am EST

  Hi,

  It is not possible to show the loading indicator through SpreadJS controls and calls. The feature is built in the SpreadJS Designer Control : https://developer.mescius.com/spreadjs/designer/index.html. However, it is possible to show the loading indicator when the file is imported through the SpreadJS API by using JavaScript technology.

  Please refer to the attached Gif and sample that displays a file loading indicator while the file loads into the SpreadJS instance (see below).

  Gif:

  Sample: spreadLoading.zip

  Please feel free to reach out if you encounter any further issues or require additional guidance.

  Best Regards,

• 

  anton.kagakin

  • Post Options:
  • Link
    Copy

  Posted 28 March 2025, 5:00 am EST

  What about programmatically close “FILE” menu?

• 

  priyam.kushwaha

  

  • Post Options:
  • Link
    Copy

  Posted 31 March 2025, 5:14 am EST - Updated 31 March 2025, 5:20 am EST

  Hi,

  Apologies for the delay caused over the weekend.

  It is possible to close the file menu in the SpreadJS Designer if the File Menu Panel is open by setting the resource FileMenu_show to the value false. Please refer to the code snippet below that illustrates the same:

  spread.import(
    file,
    function () {
      loadingDiv.style.display = "none";
      if (designer.getData("FileMenu_show")) {
        designer.setData("FileMenu_show", false);
      }
    },
    function (e) {},
    { fileType: GC.Spread.Sheets.FileType.excel }
  );

  You can further refer to the attached sample that uses the above code snippet and hides the file menu panel from the SpreadJS Designer if open (see below).

  Gif:

  Sample: spreadLoading.zip

  Please feel free to reach out if you encounter any further issues or require additional guidance.

  References:

  • getData: https://developer.mescius.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.Designer#getdata
  • setData: https://developer.mescius.com/spreadjs/api/designer/classes/GC.Spread.Sheets.Designer.Designer#setdata

  Best Regards,

• 

  anton.kagakin

  • Post Options:
  • Link
    Copy

  Posted 1 April 2025, 4:57 am EST

  Thanks!