C#

JFRobertson wrote:

why nothing is actually being written

excelDocument.Visible = true;

Excel.Application excelDocument = ExcelOperations.GetApplication();
            Excel.Workbook xlWorkbook = ExcelOperations.GetWorkbook(excelDocument);
            Excel.Worksheet xlWorksheet = ExcelOperations.GetWorksheet("", xlWorkbook);
            Excel.Range xlRange = ExcelOperations.GetRange(xlWorksheet);
            try
            {
                //This is the call to parse the tab document.  The query variable will hold a copy of everything in the text doc while it is
                //in scope.  The query is stored as a generic list to help with iteration without casting issues.
                var query = QueryTabDocument(columnsCount, filePath);
                List<ScoreTabFile> events = query.ToList();

                ////This code sets up and opens the excel score sheet so that it can be written too and read from. This 
                ////using statement is required for this code to work.  using Excel = Microsoft.Office.Interop.Excel;


                int rowCount = xlRange.Rows.Count;
                int colCount = xlRange.Columns.Count;

                //Calculate and record the air losses.
                int totalAircraftLostAA = 0;
                int totalAircraftLostSA = 0;
                ScoreCalculations.CalculateEnemyAirLosses(events, ref totalAircraftLostAA, ref totalAircraftLostSA);
                int column = 3;
                for (int row = 1; row <= rowCount; row++)
                {
                    if (string.Equals(xlRange.Cells[row, 1].Value2.ToString(), "Aircraft Kills (A-A)"))
                    {
                        Console.WriteLine(xlRange.Cells[row, 1].Value2.ToString());
                        Console.WriteLine("write attempted");
                        xlRange.Cells[row, column].Value2 = totalAircraftLostAA;
                    }
                }


                //Calculate and record ally airlosses
                ScoreCalculations.CalculateAllyAirLosses(events);

                //Calculate and record expended Ordnance
                ScoreCalculations.CalculateExpendedOrdnance(events);

                //Calculate and record ground targets hit
                ScoreCalculations.CalculateNamedGroundTargets(events);

                //xlWorkbook.Save();


            }
            catch (Exception ex)
            {
                Console.WriteLine(ex.Message);

            }
            finally
            {
                //Clean up the com objects
                GC.Collect();
                GC.WaitForPendingFinalizers();

                Marshal.FinalReleaseComObject(xlRange);
                Marshal.FinalReleaseComObject(xlWorksheet);
                xlWorkbook.Close();
                Marshal.FinalReleaseComObject(xlWorkbook);
                excelDocument.Quit();
                Marshal.FinalReleaseComObject(excelDocument);
            }

jeramyRR wrote:

My question (I know it took long enough to get to it) is if anyone can point me to any tutorials on how to create a standard text editor that can parse input and change the colors of the text like html editors and ide's do.

Bastard Programmer from Hell

taurusone wrote:

can anyone give me a C# code which does this.

Bastard Programmer from Hell

yes i know it is not restaurant and i am not ordering, it a request.

input file:

table 1:
txt1 txt2 txt3 txt4
txt5 txt6 txt7 txt8
txt4 txt3 txt2 txt1

table 2:
txt1 txt2 txt3 txt4
txt5 txt6 txt7 txt8
txt4 txt3 txt2 txt1
txt4 txt3 txt2 txt1
txt4 txt3 txt2 txt1

note that the table rows or variging. i want to write a code which

wanted output xls file:

table 1:
sume of first col: sum of say 3rd col:
txt1                txt3
txt5                txt7
txt4                txt2

table2: <same as above>


Plz dont misunderstand me point me to site which has c# code to do this or atleast give me an overview or idea about implenting this in c#.

taurusone wrote:

yes i know it is not restaurant and i am not ordering, it a request.

taurusone wrote:

Plz dont misunderstand me point me to site which has c# code to do this or atleast give me an overview or idea about implenting this in c#.

Bastard Programmer from Hell