Пример #1
0
        private void btnExcelMakeAuto_Click(object sender, EventArgs e)
        {
            String FolderName       = txtFolderPath.Text;
            string outputFolderName = "excelOutput";

            if (string.IsNullOrEmpty(FolderName))
            {
                MessageBox.Show("폴더 경로 입력");
                return;
            }

            // Output 폴더 만들기ddd
            DirectoryInfo outPutFolder = new DirectoryInfo(FolderName + $"\\{outputFolderName}");

            if (outPutFolder.Exists == false)
            {
                outPutFolder.Create();
            }

            System.IO.DirectoryInfo di = new System.IO.DirectoryInfo(FolderName);

            foreach (System.IO.FileInfo file in di.GetFiles())
            {
                if (file.Extension.ToLower().CompareTo(".txt") == 0)
                {
                    String FileNameOnly = file.Name.Substring(0, file.Name.Length - 4);
                    String fullFileName = file.FullName;

                    btnClear_Click(sender, e);
                    string str = File.ReadAllText(fullFileName, Encoding.Default);

                    //////////////////////////////////////////////////////////
                    var excelResult = new ExportFile();

                    try
                    {
                        excelResult.ExcelResult(str, file.DirectoryName + $"\\{outputFolderName}\\" + FileNameOnly + ".xlsx");
                        //txtSQLOutput.Text = "Excel Output finished";
                    } catch (IndexOutOfRangeException err)
                    {
                        //txtSQLOutput.Text = err.Message;
                    } catch (ArgumentOutOfRangeException)
                    {
                        //txtSQLOutput.Text = "Input String format is invalid";
                    } catch (InvalidOperationException)
                    {
                        //txtSQLOutput.Text = "Excel File is opened. close";
                    }
                }
            }
        }
Пример #2
0
        public void OneResultDS_withTitle_ExcelTest()
        {
            var excelResult = new ExportFile();

            excelResult.ExcelResult(File.ReadAllText("ResultSampleDatasetTitle.txt"), "ExcelResult.xlsx");
        }