Hi,
I am using UltraGridExcelExporter Export method to data from UltraGrid to Excel. During the export, I am receiving an exception for trying to set a string value with more than 32767 characters into a cell. My work around is to intercept this exception during RowExporting event and create a new worksheet setting the value there but split into multiple cells. I want to copy the first row's value and formatting from "Sheet1" to the new page. I am able to copy the values but formatting does not change even when I try to manually set it. I tried using CellFormat.SetFormatting method and nothing works. What is the best approach to this or does that method not work as I assume it should.
Thanks,
RayExample.zip
Hi Raymond,
The exception you encounter is intended behavior. Microsoft Excel has a limit of 32,767 characters for a cell.
I have addressed this question in more depth in another thread. Please let me know whether this thread represents a separate issue.