using System.Collections.Generic;

namespace QC.CorpTest.Libraries.ExcelLibrary;

public static class ExcelConstants
{
	public static class UpdateLinkOptions
	{
		public const int USERSPECIFIED = 1;

		public const int NEVERUPDATE = 2;

		public const int ALWAYSUPDATE = 3;
	}

	public static class FormatOptions
	{
		public const int TABS = 1;

		public const int COMMAS = 2;

		public const int SPACES = 3;

		public const int SEMICOLONS = 3;

		public const int NOTHING = 3;

		public const int CUSTOM = 3;
	}

	public static class PlatformOptions
	{
		public const string xlMacintosh = "xlMacintosh";

		public const string xlWindows = "xlWindows";

		public const string xlMSDOS = "xlMSDOS";
	}

	public static class CorruptLoadOptions
	{
		public const string xlNormalLoad = "xlNormalLoad";

		public const string xlRepairFile = "xlRepairFile";

		public const string xlExtractData = "xlExtractData";
	}

	public static class TemplateOptions
	{
		public const string xlWBATChart = "xlWBATChart";

		public const string xlWBATExcel4IntlMacroSheet = "xlWBATExcel4IntlMacroSheet";

		public const string xlWBATExcel4MacroSheet = "xlWBATExcel4MacroSheet";

		public const string xlWBATWorksheet = "xlWBATWorksheet";
	}

	public static class SaveAccessModeOptions
	{
		public const string xlExclusive = "xlExclusive";

		public const string xlNoChange = "xlNoChange";

		public const string xlShared = "xlShared";
	}

	public static class SaveConflictResolutionOptions
	{
		public const string xlLocalSessionChanges = "xlLocalSessionChanges";

		public const string xlOtherSessionChanges = "xlOtherSessionChanges";

		public const string xlUserResolution = "xlUserResolution";
	}

	public static class HorizontalAlignmentOptions
	{
		public const string xlHAlignCenter = "xlHAlignCenter";

		public const string xlHAlignCenterAcrossSelection = "xlHAlignCenterAcrossSelection";

		public const string xlHAlignDistributed = "xlHAlignDistributed";

		public const string xlHAlignFill = "xlHAlignFill";

		public const string xlHAlignGeneral = "xlHAlignGeneral";

		public const string xlHAlignJustify = "xlHAlignJustify";

		public const string xlHAlignLeft = "xlHAlignLeft";

		public const string xlHAlignRight = "xlHAlignRight";
	}

	public static class VerticalAlignmentOptions
	{
		public const string xlVAlignBottom = "xlVAlignBottom";

		public const string xlVAlignCenter = "xlVAlignCenter";

		public const string xlVAlignDistributed = "xlVAlignDistributed";

		public const string xlVAlignJustify = "xlVAlignJustify";

		public const string xlVAlignTop = "xlVAlignTop";
	}

	public static class GlobalConstants
	{
		public const int xlContext = -5002;

		public const int xlLTR = -5003;

		public const int xlRTL = -5004;

		public const string xlNoChangeString = "xlNoChange";

		public const int xlNoChangeInt = int.MinValue;
	}

	public static class UnderLineStyleOptions
	{
		public const string xlUnderlineStyleNone = "xlUnderlineStyleNone";

		public const string xlUnderlineStyleSingle = "xlUnderlineStyleSingle";

		public const string xlUnderlineStyleDouble = "xlUnderlineStyleDouble";

		public const string xlUnderlineStyleSingleAccounting = "xlUnderlineStyleSingleAccounting";

		public const string xlUnderlineStyleDoubleAccounting = "xlUnderlineStyleDoubleAccounting";
	}

	public static class ColorIndexOptions
	{
		public const string xlColorIndexAutomatic = "xlColorIndexAutomatic";

		public const string xlColorIndexNone = "xlColorIndexNone";

		private static List<string> values = null;

		private static object colorIndexOptionsLock = new object();

		public static List<string> GetValues()
		{
			lock (colorIndexOptionsLock)
			{
				if (values == null)
				{
					values = new List<string>();
					values.Add("xlColorIndexAutomatic");
					values.Add("xlColorIndexNone");
				}
				return values;
			}
		}
	}

	public static class PatternOptions
	{
		public const string xlPatternAutomatic = "xlPatternAutomatic";

		public const string xlPatternChecker = "xlPatternChecker";

		public const string xlPatternCrissCross = "xlPatternCrissCross";

		public const string xlPatternDown = "xlPatternDown";

		public const string xlPatternGray16 = "xlPatternGray16";

		public const string xlPatternGray25 = "xlPatternGray25";

		public const string xlPatternGray50 = "xlPatternGray50";

		public const string xlPatternGray75 = "xlPatternGray75";

		public const string xlPatternGray8 = "xlPatternGray8";

		public const string xlPatternGrid = "xlPatternGrid";

		public const string xlPatternHorizontal = "xlPatternHorizontal";

		public const string xlPatternLightDown = "xlPatternLightDown";

		public const string xlPatternLightHorizontal = "xlPatternLightHorizontal";

		public const string xlPatternLightUp = "xlPatternLightUp";

		public const string xlPatternLightVertical = "xlPatternLightVertical";

		public const string xlPatternNone = "xlPatternNone";

		public const string xlPatternSemiGray75 = "xlPatternSemiGray75";

		public const string xlPatternSolid = "xlPatternSolid";

		public const string xlPatternUp = "xlPatternUp";

		public const string xlPatternVertical = "xlPatternVertical";
	}

	public static class ChartTypeOptions
	{
		public const string xl3DArea = "xl3DArea";

		public const string xl3DAreaStacked = "xl3DAreaStacked";

		public const string xl3DAreaStacked100 = "xl3DAreaStacked100";

		public const string xl3DBarClustered = "xl3DBarClustered";

		public const string xl3DBarStacked = "xl3DBarStacked";

		public const string xl3DBarStacked100 = "xl3DBarStacked100";

		public const string xl3DColumn = "xl3DColumn";

		public const string xl3DColumnClustered = "xl3DColumnClustered";

		public const string xl3DColumnStacked = "xl3DColumnStacked";

		public const string xl3DColumnStacked100 = "xl3DColumnStacked100";

		public const string xl3DLine = "xl3DLine";

		public const string xl3DPie = "xl3DPie";

		public const string xl3DPieExploded = "xl3DPieExploded";

		public const string xlArea = "xlArea";

		public const string xlAreaStacked = "xlAreaStacked";

		public const string xlAreaStacked100 = "xlAreaStacked100";

		public const string xlBarClustered = "xlBarClustered";

		public const string xlBarOfPie = "xlBarOfPie";

		public const string xlBarStacked = "xlBarStacked";

		public const string xlBarStacked100 = "xlBarStacked100";

		public const string xlBubble = "xlBubble";

		public const string xlBubble3DEffect = "xlBubble3DEffect";

		public const string xlColumnClustered = "xlColumnClustered";

		public const string xlColumnStacked = "xlColumnStacked";

		public const string xlColumnStacked100 = "xlColumnStacked100";

		public const string xlConeBarClustered = "xlConeBarClustered";

		public const string xlConeBarStacked = "xlConeBarStacked";

		public const string xlConeBarStacked100 = "xlConeBarStacked100";

		public const string xlConeCol = "xlConeCol";

		public const string xlConeColClustered = "xlConeColClustered";

		public const string xlConeColStacked = "xlConeColStacked";

		public const string xlConeColStacked100 = "xlConeColStacked100";

		public const string xlCylinderBarClustered = "xlCylinderBarClustered";

		public const string xlCylinderBarStacked = "xlCylinderBarStacked";

		public const string xlCylinderBarStacked100 = "xlCylinderBarStacked100";

		public const string xlCylinderCol = "xlCylinderCol";

		public const string xlCylinderColClustered = "xlCylinderColClustered";

		public const string xlCylinderColStacked = "xlCylinderColStacked";

		public const string xlCylinderColStacked100 = "xlCylinderColStacked100";

		public const string xlDoughnut = "xlDoughnut";

		public const string xlDoughnutExploded = "xlDoughnutExploded";

		public const string xlLine = "xlLine";

		public const string xlLineMarkers = "xlLineMarkers";

		public const string xlLineMarkersStacked = "xlLineMarkersStacked";

		public const string xlLineMarkersStacked100 = "xlLineMarkersStacked100";

		public const string xlLineStacked = "xlLineStacked";

		public const string xlLineStacked100 = "xlLineStacked100";

		public const string xlPie = "xlPie";

		public const string xlPieExploded = "xlPieExploded";

		public const string xlPieOfPie = "xlPieOfPie";

		public const string xlPyramidBarClustered = "xlPyramidBarClustered";

		public const string xlPyramidBarStacked = "xlPyramidBarStacked";

		public const string xlPyramidBarStacked100 = "xlPyramidBarStacked100";

		public const string xlPyramidCol = "xlPyramidCol";

		public const string xlPyramidColClustered = "xlPyramidColClustered";

		public const string xlPyramidColStacked = "xlPyramidColStacked";

		public const string xlPyramidColStacked100 = "xlPyramidColStacked100";

		public const string xlRadar = "xlRadar";

		public const string xlRadarFilled = "xlRadarFilled";

		public const string xlRadarMarkers = "xlRadarMarkers";

		public const string xlStockHLC = "xlStockHLC";

		public const string xlStockOHLC = "xlStockOHLC";

		public const string xlStockVHLC = "xlStockVHLC";

		public const string xlStockVOHLC = "xlStockVOHLC";

		public const string xlSurface = "xlSurface";

		public const string xlSurfaceTopView = "xlSurfaceTopView";

		public const string xlSurfaceTopViewWireframe = "xlSurfaceTopViewWireframe";

		public const string xlSurfaceWireframe = "xlSurfaceWireframe";

		public const string xlXYScatter = "xlXYScatter";

		public const string xlXYScatterLines = "xlXYScatterLines";

		public const string xlXYScatterLinesNoMarkers = "xlXYScatterLinesNoMarkers";

		public const string xlXYScatterSmooth = "xlXYScatterSmooth";

		public const string xlXYScatterSmoothNoMarkers = "xlXYScatterSmoothNoMarkers";
	}

	public static class RowColOptions
	{
		public const string xlRows = "xlRows";

		public const string xlColumns = "xlColumns";
	}

	public static class ChartLocationOptions
	{
		public const string xlLocationAsNewSheet = "xlLocationAsNewSheet";

		public const string xlLocationAsObject = "xlLocationAsObject";

		public const string xlLocationAutomatic = "xlLocationAutomatic";
	}

	public static class AxisTypes
	{
		public const string xlCategory = "xlCategory";

		public const string xlValue = "xlValue";

		public const string xlSeriesAxis = "xlSeriesAxis";
	}

	public static class AxisGroupOptions
	{
		public const string xlPrimary = "xlPrimary";

		public const string xlSecondary = "xlSecondary";
	}

	public static class LineStyleOptions
	{
		public const string xlContinuous = "xlContinuous";

		public const string xlDash = "xlDash";

		public const string xlDashDot = "xlDashDot";

		public const string xlDashDotDot = "xlDashDotDot";

		public const string xlDot = "xlDot";

		public const string xlDouble = "xlDouble";

		public const string xlSlantDashDot = "xlSlantDashDot";

		public const string xlLineStyleNone = "xlLineStyleNone";
	}

	public static class BorderIndexOptions
	{
		public const int xlDiagonalDown = 5;

		public const int xlDiagonalUp = 6;

		public const int xlEdgeBottom = 9;

		public const int xlEdgeLeft = 7;

		public const int xlEdgeRight = 10;

		public const int xlEdgeTop = 8;

		public const int xlInsideHorizontal = 12;

		public const int xlInsideVertical = 11;
	}

	public static class FileFormatOptions
	{
		public const string xlAddIn = "";

		public const string xlCSV = "xlCSV";

		public const string xlCSVMac = "";

		public const string xlCSVMSDOS = "";

		public const string xlCSVWindows = "";

		public const string xlCurrentPlatformText = "";

		public const string xlDBF2 = "";

		public const string xlDBF3 = "";

		public const string xlDBF4 = "";

		public const string xlDIF = "";

		public const string xlExcel2 = "";

		public const string xlExcel2FarEast = "";

		public const string xlExcel3 = "";

		public const string xlExcel4 = "";

		public const string xlExcel4Workbook = "";

		public const string xlExcel5 = "";

		public const string xlExcel7 = "";

		public const string xlExcel9795 = "";

		public const string xlHtml = "";

		public const string xlIntlAddIn = "";

		public const string xlIntlMacro = "";

		public const string xlSYLK = "";

		public const string xlTemplate = "";

		public const string xlTextMac = "";

		public const string xlTextMSDOS = "";

		public const string xlTextPrinter = "";

		public const string xlTextWindows = "";

		public const string xlUnicodeText = "";

		public const string xlWebArchive = "";

		public const string xlWJ2WD1 = "";

		public const string xlWJ3 = "";

		public const string xlWJ3FJ3 = "";

		public const string xlWK1 = "";

		public const string xlWK1ALL = "";

		public const string xlWK1FMT = "";

		public const string xlWK3 = "";

		public const string xlWK3FM3 = "";

		public const string xlWK4 = "";

		public const string xlWKS = "";

		public const string xlWorkbookNormal = "";

		public const string xlWorks2FarEast = "";

		public const string xlWQ1 = "";

		public const string xlXMLSpreadsheet = "";
	}

	public static class ExcelNumberFormatOptions
	{
		public const string xlText = "@";

		public const string xlDateTime = "[$-409]m/d/yy h:mm AM/PM;@";

		public const string xlDouble = "0.00000";

		public const string xlLong = "0";
	}
}
