EBDN - Community - Question & Answers

  2. Home
  3. Community
  4. Question & Answer
  5. Application Development
  6. C# Development
  7. Inquiry Regarding Worksheet Export Bug Using Interop
  • Show results from selected filters below:
    1. Check All
    2. Uncheck All
Categories
Categories:   All Categories
Suggested keywords
x
New
 Bug

Inquiry Regarding Worksheet Export Bug Using Interop

C# Development
  C# Development
Hyojoong Kim
  Hyojoong Kim
  Tuesday, 06 May 2025
  2 Replies
  1.7K Visits
0
Votes
Undo
Hi All,

When exporting a worksheet manually in EB via Export → Excel → .xls, the value in the relevant cell appears as shown in #1:

$4949|436.000000|328.000000|00B4E4A3$4905|380.000000|346.000000|00B4E4A3$4686|158.000000|346.000000|00B4E4A3$180649|1239.500000|570.000000|0150CA46$180628|2524.000000|570.000000|0150CA46$180611|2348.000000|569.500000|0150CA46$180586|2140.500000|570.000000|0150CA46$180555|1902.000000|570.000000|0150CA46$180538|1685.000000|570.000000|0150CA46$180515|1000.000000|570.000000|0150CA46$180488|843.000000|570.000000|0150CA46$180468|676.000000|376.500000|0150CA46


However,
When exporting the same worksheet using Interop with the following code:


IAucObject select = _ebApp.Selection.Item(1);



IAucWorksheet ws = select.OpenWorksheet("TEST_WORKSHEET" ,false);

string savePath = Path.Combine(@"C:\Users\TEST\Desktop", "test.xlsx");



ws.Export(AucWorksheetExportType.aucWSExportXLS, savePath);


the value in the same cell appears as shown in #2:

'$4949|436.000000|328.000000|00B4E4A3$4905|380.000000|346.000000|00B4E4A3$4686|158.000000|346.000000|00B4E4A3$180649|1239.500000|570.000000|0150CA46$180628|2524.000000|570.000000|0150CA46$180611|2348.000000|569.500000|0150CA46$180586|2140.500000|570.000000


I am currently using EB 2024 CU12, and I would like to know whether this is a bug in EB or if the issue is caused by incorrect usage of the code.

Thank you in advance for your support.
0