示例#1
0
        protected override void Execute(CodeActivityContext context)
        {
            var excelpath  = ExcelPath.Get(context);
            var pageindex  = SheetIndex.Get(context);
            var txtpath    = TxtPath.Get(context);
            var splitchar  = SplitChar.Get(context);
            var addheaders = AddHeaders.GetType();

            Workbook wb = new Workbook();

            wb.LoadFromFile(@excelpath);
            Worksheet ws = wb.Worksheets[pageindex];
            DataTable dt = ws.ExportDataTable();

            //TXT VARSA İÇİNİ TEMİZLE
            if (File.Exists(txtpath))
            {
                File.WriteAllText(txtpath, "");
            }
            //BAŞLIK
            if (AddHeaders)
            {
                string[] columnNames = dt.Columns.Cast <DataColumn>().Select(x => x.ColumnName).ToArray();
                File.AppendAllText(@txtpath, string.Join(splitchar, columnNames) + Environment.NewLine);
            }
            //SATIRLAR
            foreach (DataRow dtR in dt.Rows)
            {
                File.AppendAllText(@txtpath, string.Join(splitchar, dtR.ItemArray) + Environment.NewLine);
            }
        }
示例#2
0
        private IncludeProperties RemoveIfExit(IList <string> names, string name)
        {
            var theOne = TryFindIt(names, name);

            if (string.IsNullOrWhiteSpace(theOne))
            {
                return(this);
            }
            names.Remove(theOne);
            Properties = string.Join(SplitChar.ToString(), names);
            return(this);
        }
示例#3
0
 public override string ToString()
 {
     return($"Current sc: {SplitChar.ToString()} -> L: {LowNode?.SplitChar ?? '#'} , E: {EqNode?.SplitChar ?? '#'} H: {HiNode?.SplitChar ?? '#'}");
 }