﻿using DocumentFormat.OpenXml;
using DocumentFormat.OpenXml.Packaging;
using DocumentFormat.OpenXml.Spreadsheet;
using System;
using System.Collections.Generic;
using System.Text;

namespace Middleware.Excel.Interfaces
{
    public interface IExcelHelper
    {
        WorksheetPart AddSheetToSpreadsheet(SpreadsheetDocument spreadsheet, WorkbookPart workbookpart, int sheetID, string sheetName);

        string GetColumnName(int columnIndex);
        string GetCellPositionName(uint rowIndex, int columnIndex);

        void AddToRow(Row row, string value, CellValues cellValue, uint styleIndex = 0);
        void AddToRowAtPostion(Row row, string value, CellValues cellValue, int columnIndex, uint styleIndex = 0);

        Row GetOrCreateRow(UInt32Value rowCounter, SheetData sheetData);
    }
}
