示例#1
0
        static void Main(string[] args)
        {
            Stopwatch stopWatch = new Stopwatch();

            stopWatch.Start();
            String file        = @"C:\Users\Uther\Desktop\РАФ\УССО_30_01.xlsx";
            String path2       = @"C:\Users\Uther\Desktop\РАФ\NotValid.xlsx";
            bool   InDiffLists = false;

            var dataSet = ReadExcel.GetDataSetFromExcelFile(file);

            Console.WriteLine(string.Format("reading file: {0}", file));
            Console.WriteLine(string.Format("coloums: {0}", dataSet.Tables[0].Columns.Count));
            Console.WriteLine(string.Format("rows: {0}", dataSet.Tables[0].Rows.Count));

            var lists = DataIntoList.IntoList(dataSet);

            var NotValidList = lists.Item2;

            FileStream objFileStrm = File.Create(path2);

            objFileStrm.Close();

            WriteExcel.SetDataSetFromExcelFile(InDiffLists, NotValidList, path2);//NotValid into Excel

            var RowObjInfoListJSON = DataIntoList.IntoJList(lists.Item1);
            //var json = JsonConvert.SerializeObject(RowObjInfoListJSON, Formatting.Indented);
            int count = lists.Item1.Count;

            JSON.ToJSON(count, RowObjInfoListJSON);
            stopWatch.Stop();

            TimeSpan ts = stopWatch.Elapsed;
            // Format and display the TimeSpan value.
            string elapsedTime = String.Format("{0:00}:{1:00}:{2:00}.{3:00}",
                                               ts.Hours, ts.Minutes, ts.Seconds,
                                               ts.Milliseconds / 10);

            Console.WriteLine("RunTime " + elapsedTime);

            Console.WriteLine(lists.Item1.Count);

            Console.ReadKey();
        }
示例#2
0
 public static void Main(string[] args)
 {
     // Read(@"D:\document\gtx.docx");
     WriteExcel.inputExcel();
 }
示例#3
0
        public void CreazioneLtturaFile()
        {
            //in primo luogo mi creo un ambiente pulito
            string p        = @"C:\\temp\test";
            string fileName = @"OutputTest";

            if (!Directory.Exists(p))
            {
                Directory.CreateDirectory(p);
            }
            foreach (FileInfo file in new DirectoryInfo(p).GetFiles())
            {
                if (file.Name.Contains(fileName))
                {
                    file.Delete();
                }
            }
            //parto
            List <provaIniezioneClasse> tmList = new List <provaIniezioneClasse>();
            provaIniezioneClasse        tm     = new provaIniezioneClasse();

            tm.prova1   = 1;
            tm.prova2   = "prova2";
            tm.prova3   = "prova3 1 time";
            tm.TestDate = DateTime.Now.Date;
            tmList.Add(tm);
            provaIniezioneClasse tm2 = new provaIniezioneClasse();

            tm2.prova1   = 123;
            tm2.prova2   = "prova2";
            tm2.prova3   = "prova3 1 time";
            tm2.TestDate = DateTime.UtcNow;
            tmList.Add(tm2);

            provaIniezioneClasse tm3 = new provaIniezioneClasse();

            tm3.prova2 = "prova2";
            tmList.Add(tm3);

            WriteExcel wr = new WriteExcel();

            wr.WriteExcelFile(tmList, p, fileName);
            Assert.IsTrue(File.Exists(Path.Combine(p, fileName + ".xlsx")));//l'ho creato è già cosa buona e giusta

            ReadEcxel rd   = new ReadEcxel();
            DataTable read = new DataTable();

            rd.ReadEcxelFile(out read, p, fileName);
            Assert.IsTrue(tmList.Count == read.Rows.Count);//
            int i = 0;

            foreach (DataRow rows in read.Rows)
            {
                provaIniezioneClasse tmp = tmList[i++];
                Assert.IsTrue(rows[0].ToString() == tmp.prova1.ToString());
                Assert.IsTrue((rows[1].ToString() == "" && string.IsNullOrEmpty(tmp.prova2)) || (rows[1].ToString() == tmp.prova2.ToString()));
                Assert.IsTrue((rows[2].ToString() == "" && string.IsNullOrEmpty(tmp.prova3)) || (rows[2].ToString() == tmp.prova3.ToString()));
                Assert.IsTrue((tmp.TestDate != DateTime.MinValue && rows[3].ToString() == tmp.TestDate.ToString()) ||
                              (tmp.TestDate == DateTime.MinValue && rows[3].ToString() == ""));
            }
            // adesso lo rileggo e confronto il contenuto
        }