ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Storing generic objects in workbook via automation (https://www.excelbanter.com/excel-programming/310155-storing-generic-objects-workbook-via-automation.html)

Nacho Nachev

Storing generic objects in workbook via automation
 
Hello,

I am accessing MS Excel via automation from C# module. I need to store some
occasional data in an Excel workbook, but not in a spreadsheet. I tried to
store it in a custom DocumentProperty. Unformtunately it cannot store
generic objects and I serialized my object into string. Now the limitaion is
that a string cannot store more than 255 char, so I can split the content up
to several strings, but I would like to avoid this if possible.

I would like to ask if there is another way for storing custom generic
objects in an Excel workbook, through automation.

Thank you for your time,
Nacho




All times are GMT +1. The time now is 07:23 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com