_exportToExcel.DecodeExcelFormula(wb, data, decryptExpressionRange, decryptColumnName);
one of the value got changed in decryptExpressionRange, now not able to map with the excel column. Please Help, it is urgent Production Issue.
Which Aspose API/library you are using? Could you please provide more details with sample project and sample files (please zip the resource files prior attaching). We will check your issue/requirements and assist you soon.
ExcelAsposeHandlr.zip (604.5 KB)
The attached ExcelAsposeHandlr we are using. Let me give you a background about what we are doing from our application and what is the ask.
public string EncodeExcelFormula(string formula, Worksheet worksheet, string accountIdColumn, string dataDetailTypeIdRow)
and
public DataTable DecodeExcelFormula(Workbook workbook, DataTable dt, string decryptExpressionRange, string decryptColumnName)
we are using from our application. EncodeExcelFormula is encoding a expression and DecodeExcelFormula is decoding the same encoded expression.
Now all this encoding and decoding is happening based on a dataset defined in the decryptExpressionRange(“rngAcctIdDataDtlTypeId” is the defined range in the shared excel file). In the attachment if you open the excel file, you will be able to see the data defined in the “rngAcctIdDataDtlTypeId”.
So if the expression is “=O26+W337+W378”, after calling “EncodeExcelFormula” it will convert the expression as “=104_70003+110_70295+110_70336” and then we are saving it to the database. Now during fetching the data in the very same way we are calling “DecodeExcelFormula(Workbook workbook, DataTable dt, string decryptExpressionRange, string decryptColumnName)”. decryptColumnName is the column which we are trying to decode from the DataTable dt. So after calling the DecodeExcelFormula, the expression “=104_70003+110_70295+110_70336” will be changed to “=O26+W337+W378”, and we are using the same in the excel report.
Now the problem started when we changed some of the data in the decryptExpressionRange. we have changed the value in B16 to “1,2,3,4,5,6,7…”. Now we want as earlier it was decoding 100 as K, 101 as L and so on, It should do the same for 1 as K, 2 as L, 3 as M and so on.
We do not have any option to not change the data because based on this new data we have done lots of changes at our end and also released in the Production. So it is not possible to change “1,2,3,4…” to “100, 101, 102, 103…”. Please let me know if you need any other information, any help will be really appreciated.
Thank you for providing the details and code snippets.
It could be related to the logic and algorithms you’ve created for parsing and decoding. Please allow us some time to carefully study your scenario and assess your intricate situation before we can share our insights and provide you with an update. Hopefully, we will get back to you soon.