The feature I expect in future versions of SpreadNET

The feature I expect in future versions of SpreadNET

Posted by: 8166582 on 22 May 2024, 7:52 am EST

• 

  8166582

  • Post Options:
  • Link
    Copy

  Posted 22 May 2024, 7:52 am EST

  In the current version of SpreadNET, it is not yet possible to read the CustomProperties of the sheet in Excel files. I hope to increase access to this property in future versions.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 23 May 2024, 5:51 pm EST

  Hi,

  You can read the custom properties of the Excel file by iterating over the values of IWorkSheet’s CustomDocumentProperties property. Here is the code snippet for the same:

  var props = fpSpread1.AsWorkbook().CustomDocumentProperties;
  for(int i = 0; i < props.Count; i++)
  {
      Debug.WriteLine(props[i].Name + " : " + props[i].ToString());
  }

  We have also attached a sample application for your reference. See ReadDocProperties.zip

  Please let us know if your requirement differs from our understanding.

  Thanks & Regards,
  
  Aastha

• 

  8166582

  • Post Options:
  • Link
    Copy

  Posted 23 May 2024, 8:55 pm EST - Updated 23 May 2024, 9:26 pm EST

  Hi,
  
  I am aware that the new version of SpreadNET has added the ’CustomizaDocumentProperties‘ property that can access asworkbooks. What I want to access is the ’CustomProperties‘(just like in VBA ) property of the worksheet, not the ’CustomizaDocumentProperties‘ of the workbook. However, this interface of
  
  ’CustomProperties‘ was not found in SpreadNET V17.

• 

  aastha.gupta

  

  • Post Options:
  • Link
    Copy

  Posted 27 May 2024, 12:53 pm EST

  Hi,

  Thanks for providing the image reference.

  We are currently discussing this requirement with our developers. [Internal Tracking ID: SPNET-38746] We will update you on this as soon as we hear back from them.

  Thanks & Regards,
  
  Aastha

• 

  8166582

  • Post Options:
  • Link
    Copy

  Posted 28 May 2024, 11:30 am EST

  Hi，
  
  Thank you for paying attention to my suggestions.I look forward to this feature being provided in the next version.

• 

  8166582

  • Post Options:
  • Link
    Copy

  Posted 9 December 2024, 11:32 pm EST

  Great, spread.net v18 now supports the ‘CustomProperties’ of worksheet property.