using Spire.Xls;
using Spire.Xls.Core;
using System;
using System.IO;


namespace HStation.RevitDev.RevitDataExport.Utility
{
    internal class ExcelHelper
    {
        private Workbook _workbook;
        private Worksheet _sheet;

        public ExcelHelper()
        {
            Workbook workbook = new Workbook();
            workbook.Worksheets.Clear();
            _workbook = workbook;
        }

        internal void SetCurrentSheet(string sheetName)
        {
            if (_workbook.Worksheets[sheetName] == null)
            {
                _sheet = _workbook.Worksheets.Add(sheetName);
            }
        }

        internal void SaveAs(string filePath)
        {
            _workbook.SaveToFile(filePath);
        }

        internal void Write(int rowIndex, int columnIndex, string content)
        {
            _sheet.Range[rowIndex, columnIndex].Value = content;
        }

        private static char[] InvalidChars = { ':', '：', '\\', '/', '?', '？', '【', '[', ']', '】', '*' };
        public static string UniformSheetName(string name)
        {
            foreach (var invalidChar in InvalidChars)
            {
                name = name.Replace(invalidChar, '-');
            }
            return name;
        }
    }
}