From 4902d3361008579949fbc7734b5ed25ed2063691 Mon Sep 17 00:00:00 2001
From: Serghei Cebotari <serghei@cebotari.ru>
Date: Mon, 28 Apr 2025 10:10:00 +0300
Subject: Refactor worksheet selection to prioritize active tab in Excel
 parsers

---
 RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs | 2 +-
 1 file changed, 1 insertion(+), 1 deletion(-)

(limited to 'RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs')

diff --git a/RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs b/RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs
index 206200d..eb4e1bb 100644
--- a/RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs
+++ b/RhSolutions.SkuParser.Api/Services/CommonExcelParser.cs
@@ -9,7 +9,7 @@ public class CommonExcelParser : ISkuParser
 	public Dictionary<Product, double> ParseProducts(IFormFile file)
 	{
 		using XLWorkbook workbook = new(file.OpenReadStream());
-		IXLWorksheet ws = workbook.Worksheet(1);
+		IXLWorksheet ws = workbook.Worksheets.FirstOrDefault(ws => ws.TabActive) ?? workbook.Worksheet(1);
 
 		var leftTop = ws.FirstCellUsed()?.Address;
 		var rightBottom = ws.LastCellUsed()?.Address;
-- 
cgit v1.2.3