Read data of specific columns only

[sovetkin]

Hello everyone!!!

I have two scenario when I need to read data from specified columns.
The first one is when excel metadata specify exceeded number of columns with data, for instance:

<?xml version="1.0" encoding="UTF-8" standalone="yes"?>
<worksheet xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main" xmlns:r="http://schemas.openxmlformats.org/officeDocument/2006/relationships" xmlns:mc="http://schemas.openxmlformats.org/markup-compatibility/2006" mc:Ignorable="x14ac" xmlns:x14ac="http://schemas.microsoft.com/office/spreadsheetml/2009/9/ac">
	<dimension ref="A1:XAL16234"/>
	<sheetViews>
		<sheetView tabSelected="1" workbookViewId="0">
			<pane xSplit="5" ySplit="6" topLeftCell="F7" activePane="bottomRight" state="frozen"/>
			<selection pane="topRight" activeCell="F1" sqref="F1"/>
			<selection pane="bottomLeft" activeCell="A7" sqref="A7"/>
			<selection pane="bottomRight" activeCell="A6" sqref="A6"/>
		</sheetView>
	</sheetViews>
	<sheetFormatPr defaultColWidth="9.109375" defaultRowHeight="10.199999999999999" x14ac:dyDescent="0.3"/>
	<cols>
		<col min="1" max="1" width="10.5546875" style="12" customWidth="1"/>
		<col min="2" max="2" width="7" style="12" customWidth="1"/>
		<col min="3" max="3" width="11.6640625" style="13" customWidth="1"/>
		<col min="4" max="4" width="19.33203125" style="14" customWidth="1"/>
		<col min="5" max="5" width="7.44140625" style="15" customWidth="1"/>
		<col min="6" max="6" width="10.21875" style="12" customWidth="1"/>
		<col min="7" max="7" width="13.33203125" style="12" customWidth="1"/>
		<col min="8" max="8" width="4.88671875" style="12" customWidth="1"/>
		<col min="9" max="9" width="10.5546875" style="16" customWidth="1"/>
		<col min="10" max="10" width="10.6640625" style="12" customWidth="1"/>
		<col min="11" max="11" width="8.77734375" style="12" customWidth="1"/>
		<col min="12" max="12" width="10.44140625" style="40" customWidth="1"/>
		<col min="13" max="13" width="10.77734375" style="40" customWidth="1"/>
		<col min="14" max="14" width="4.77734375" style="13" customWidth="1"/>
		<col min="15" max="15" width="11.88671875" style="76" bestFit="1" customWidth="1"/>
		<col min="16" max="16" width="9.33203125" style="76" customWidth="1"/>
		<col min="17" max="17" width="7.5546875" style="76" customWidth="1"/>
		<col min="18" max="16384" width="9.109375" style="12"/>
	</cols>```

Actually, the excel file keeps data only in 18 columns, but MiniExcel tries to read data in 16384 columns.
I don't know which parameter affects this. Maybe this one 

> <dimension ref="A1:XAL16234"/>

or maybe this one 

> <col min="18" max="16384"

When I read the file I get the array of data with dimension 16384 (columns) x 16 000 (rows) where most of the cells are empty. This leads to a big delay in reading or sometimes to corruption of the application.

So, I can solve this issue by specifing the range of rows to read.

The second one I need to read data from specific columns because I need to upload data from different columns to different places

Is it possible to read data from specified columns only using MiniExcel?