Overview
Looking for a way to copy the sheet of your Excel workbook into a new Excel workbook or finding it hard to combine multiple Excel files into a single workbook with all sheets combined to one file directly in Appian? Then here you have the Excel Utility plug-in that brings you two helpful smart services.
Key Features & Functionality
Note: Requires a valid Aspose Cells for Java license. Use the link https://purchase.aspose.com/temporary-license to get a temporary license. The complete license can be bought after testing the functionality. Check out the KB article for Aspose Plug-ins FAQ.
Whet Value"0.45678%" set Format Cells "Percentage"=>"Decimal Places"=>2, use "readexcelsheetwithfilter" will overflow,it return "0.0044539999999999996". Can you fix it ?
Hello Author
When using readexcelsheetwithfilter, if the cell is set to "cell format", some values will overflow.For example:1. When the value is 0.004, set the cell "number" format to 0.00, it will overflow and return 0.0040000000000000001.1. When the value is 0.4454%, set the cell "percentage" format to 4 decimal places, it will overflow and return 0.00445399999999999996.Can it be fixed?