Custom properties

Hello, The worksheet interface of Excel 2003 supports custom properties. Does XlsIO support custom properties too? Or how can I save custom data on a per worksheet basis? Best regards, Holger

Hi Holger, Are you referring to the custom document properties found under File>>Properties>>Custom Tab in MS Excel 2003? Please clarify. Thanks, Stephen. >Hello, > >The worksheet interface of Excel 2003 supports custom properties. Does XlsIO support custom properties too? Or how can I save custom data on a per worksheet basis? > >Best regards, >Holger

Hi Stephen, No, you mentioned the BuiltinDocumentProperties and/or CustomDocumentProperties of the workbook object. The CustomProperties collection represents CustomProperty objects for worksheets. CustomProperies can store information within a worksheet. They are similar to the DocumentProperties in the Office XP model, except they are stored with a worksheet instead of the whole document. I don''t want to store the information in regular cells of a worksheet. I hope, that will clarify my question. Best regards, Holger >Hi Holger, > >Are you referring to the custom document properties found under > >File>>Properties>>Custom Tab in MS Excel 2003? > >Please clarify. > >Thanks, > >Stephen. > >>Hello, >> >>The worksheet interface of Excel 2003 supports custom properties. Does XlsIO support custom properties too? Or how can I save custom data on a per worksheet basis? >> >>Best regards, >>Holger

Hi Holger, Sorry for the delay in getting back to you. I will look into it and get back to you soon. Best regards, Stephen.

Hi Stephen, Did you find out something? Best regards, Holger.

Hi Holger, Sorry for the delay in getting back to you. Could you please let me know if this is a feature in MS Excel? If so please let me know how these properties can be added using MS Excel? Thanks, Bharath.

Hi Bharath, please have a look at the Excel 2003 object model. ClassWorksheet + CustomProperties As CustomProperties The CustomProperties collection allows adding custom properties. Best regards, Holger

Hi Holger, Thank you for your patience in providing the additional information that we had requested. I am able to understand the issue now, you need to read / write name value pairs similar to the one found on sheet one of this workbook WCP.zip I have contacted the development team regarding this issue and will get back to you as soon as possible. Thanks, Stephen. >Hi Bharath, > >please have a look at the Excel 2003 object model. > >ClassWorksheet >+ CustomProperties As CustomProperties > >The CustomProperties collection allows adding custom properties. > >Best regards, >Holger >

Hi Stephen, That''s exactly what I want! Best regards, Holger

Hi Holger, Thanks for the update. It''s in our to do list and will definitely be implemented in a service pack after version 4.2 gets released. An approximate estimate would be 4 weeks time. Please let me know if this timeframe is acceptable for you if not I can check with the developlement team and see if this could be implemented sooner. Thanks, Stephen. >Hi Stephen, > >That''s exactly what I want! > >Best regards, >Holger

Hi Stephen, I am very pleased to hear that the issue is in your to do list. You mentioned a timeframe of about 4 weeks. That is acceptable to me. Thanks. Holger >Hi Holger, > >Thanks for the update. It''s in our to do list and will definitely be implemented in a service pack after version 4.2 gets released. An approximate estimate would be 4 weeks time. > >Please let me know if this timeframe is acceptable for you if not I can check with the developlement team and see if this could be implemented sooner. > >Thanks, >Stephen. > >>Hi Stephen, >> >>That''s exactly what I want! >> >>Best regards, >>Holger