Queries
a. Which versions of Excel are supported by udi-Magic Software ?
b. Which file formats are supported by udi-Magic Software?
c. Can I use Formulas in the Excel sheet ?
d. How do I write Formulas in Excel ? Is support providing in writing Excel Formulas ?
e. I want to merge information from multiple Excel files into a single file ? How do I do it ?
Ans
a. udi-Magic supports Excel 97 and higher versions. i.e. Excel 97, Excel 2003, Excel 2007, Excel 2010, Excel 2013, Excel 2016 including the latest version / release of Excel.
b. XLS, XLSX, CSV, XLSB.
PS: By default, the XLS and XLSX files are shown in the selection box in udi-Magic. You must change the File-type as "All files" to select CSV or XLSB files.
c. Yes.
PS: You can use any FORMULAs supported in Excel. In brief, you can use TEXT, NUMBERS, DATE, FORMULAs as you do normally in any Excel file.
d. Please refer the Excel documentation on using Formulas in Excel.
e. Please refer the Excel documentation or consult the vendor from whom you purchased Excel.