Microsoft Excel Style Sheet

T

tomsthumb

I have an Excel workbook which gets passed between two applications to
populate worksheets. The workbook starts as a template file and is saved to
a users's hard drive. Using C#, I read data from a database then populate
the worksheets accordingly.
One worksheet requires that I create a style. This style is used to
indicate headings. When all the workbook processing is within a single C#
class, I am able to create the style dynamically without issue. When I open
the workbook in one class and pass it to another class, I am able to populate
cells without issue. I am able to modify existing styles, but I receive an
error "Add method of Styles class failed" error trying to create the new
style from the called class.
I have to say that this seems kind of weird. Any thoughts?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top