I am developing a java project using aspose cell , I would like to import a result set to excel than add a new column with validation list after it. It works fine if the result data is selected all from table (select * from table). However, when i selected specific columns (select columnA, columnB from table), i cannot add the validation list to excel in column 3. It seems that validation can only be added after the total number of columns from table. (e.g. 10 columns from table, validation can only be added in column 11 even i select only 2 columns to insert into the excel)
I am using aspose cell version 18.7, thanks.