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?

[michelebastione]

Hello, sorry for the late reply. You can solve this by using the MiniExcel.QueryRange and providing the range of your actual data, and you can filter for the columns you need by applying a select statement to the query.