SpreadsheetGear.Factory.GetWorkbook(filename) replacing empty value with 0 in excel file
<p>I have DevEx gridControl with some data from DB. </p>

<pre><code>gridControl.ExportToXlsx(filename, new XlsxExportOptions(TextExportMode.Value));
</code></pre>

<p>this code block Works fine and export data to excel. after export, I am opening and closing excel file using SpreadsheetGear like below...</p>

<pre><code>WorkBook = Factory.GetWorkbook(filename);
WorkBook.Save();
WorkBook.Close();
</code></pre>

<p>My intention is to perform some task after opening excel file but This opening and closing of excel file replacing all empty values in excel file with 0 (zero).</p>

<p>Can anyone help me to understand why this is happening and how can I fix this.</p>

<p>one more point to add, if I export data with <code>TextExportMode.Text</code> option then SpreadsheetGear is not replacing empty values with 0 but exporting as Text will not solve my purpose.</p>

<p>Thanks in advance.</p>