//*******************************************************************************************//
//                                                                                           //
// Download Free Evaluation Version From: https://bytescout.com/download/web-installer       //
//                                                                                           //
// Also available as Web API! Get Your Free API Key: https://app.pdf.co/signup               //
//                                                                                           //
// Copyright © 2017-2020 ByteScout, Inc. All rights reserved.                                //
// https://www.bytescout.com                                                                 //
// https://pdf.co                                                                            //
//                                                                                           //
//*******************************************************************************************//


using System;
using System.Collections.Generic;
using System.Text;
using System.Diagnostics;
using System.IO;
using Bytescout.Spreadsheet;
using Bytescout.Spreadsheet.Charts;
using Bytescout.Spreadsheet.Constants;
using System.Drawing;

namespace CSharp
{
	class Program
	{
		static void Main(string[] args)
		{
			try
			{
				// create new Spreadsheet object
				Spreadsheet spreadsheet = new Spreadsheet();

				// add new worksheet
				Worksheet sheet = spreadsheet.Workbook.Worksheets.Add("Sample");

				// add a constants
				for (int i = 1; i < 8; i++)
				{
					sheet[i, 1].Value = i;
				}

				// add a formulas
				sheet.Range("D2:D8").Formula = "=RAND()*10";

				//Select the cells containing constants
				Range range1 = sheet.Range("A1:E9").SpecialCells(XlCellType.Constants, null);
				range1.FillPattern = PatternStyle.Solid;
				range1.FillPatternForeColor = Color.Yellow;

				//Select the cells containing formulas
				Range range2 = sheet.Range("A1:E9").SpecialCells(XlCellType.Formulas, null);
				range2.FillPattern = PatternStyle.Solid;
				range2.FillPatternForeColor = Color.Cyan;

				if (File.Exists("Output.xls"))
				{
					File.Delete("Output.xls");
				}

				// Save it as XLS
				spreadsheet.SaveAs("Output.xls");

				// close the document
				spreadsheet.Close();

				// open output XLS
				Process.Start("Output.xls");
			}
			catch (Exception e)
			{
				Console.WriteLine("CAN NOT EXECUTE: " + e.ToString());
				Console.WriteLine("\nPress any key to exit");
				Console.ReadKey();
			}
		}
	}
}
