Skip to content

Latest commit

 

History

History
142 lines (125 loc) · 4.34 KB

README.md

File metadata and controls

142 lines (125 loc) · 4.34 KB

FilesToXml

This is a console app for converting office/text files to xml.
Supported types for now:

  • xlsx
  • xls
  • csv
  • txt
  • doc
  • docx
  • xml
  • json
  • tsv
  • dbf

console usage: 
./Convertor.exe -i xlsx.xlsx -o xlsx.xml -e 1251 -s
Short key Long key Description
-i --in Required. Set paths to input files (Example: -i C:\1.txt C:\2.txt)
-o --out Set path to output file, if path is empty print to console
-s --forceSave (Default: false) Save output file even if exist
-d --delimiters (Default: auto) Set delimiters for csv files
-D --searchingDelimiters         (Default: ; | ,) Set delimiters for auto-search in csv files
-e --inEncoding (Default: 65001) Set int32 codepages for input files (Example: -i C:\1.txt C:\2.txt -e 1251 65001)
-E --outEncoding (Default: 65001) Set int32 codepage for output file
-l --labels Set labels for input files
-F --disableFormat (Default: false) Disable format output xml
--support Display supported types

library usage:

using ConverterToXml.Converters;

IConvertable convertor = file.Type switch
{
    SupportedFileExt.xls => new XlsToXml(),
    SupportedFileExt.xlsx => new XlsxToXml(),
    SupportedFileExt.txt => new TxtToXml(),
    SupportedFileExt.csv => new CsvToXml(),
    SupportedFileExt.docx => new DocxToXml(),
    SupportedFileExt.doc => new DocToXml(),
    SupportedFileExt.xml => new XmlToXml(),
    _ => throw new NotImplementedException($"Unsupported type")
};
var xml = convertor switch
{
    IDelimiterConvertable c => c.ConvertByFile(file.Path, file.Delimiter, file.Encoding),
    IEncodingConvertable c => c.ConvertByFile(file.Path, file.Encoding),
    { } c => c.ConvertByFile(file.Path)
};

Result structure

xlsx/xls

  • DATA:
    • DATASET:
    • ext
    • label (optional)
    • path
      • TABLE:
      • name
      • id
        • R :
        • id
        • C{N}
        • METADATA:
        • columns
        • rows

csv/tsv/dbf

  • DATA:
    • DATASET:
    • ext
    • path
    • label (optional)
      • TABLE:
      • id
        • R :
        • id
        • C{N}
        • METADATA:
        • columns
        • rows

xml

  • DATA:
    • DATASET:
    • label (optional)
    • ext
    • path
      • {SourceXML}

text

  • DATA:
    • DATASET:
    • ext
    • path
    • label (optional)
      • TEXT
      • {PlainText}

docx/doc

  • DATA:
    • DATASET:
    • ext
    • path
    • label (optional)
      • TEXT:
      • id
        • R :
        • level
        • id
        • C{N}
      • TABLE:
      • id
        • R :
        • id
        • C{N}
        • METADATA:
        • columns
        • rows

json

  • DATA:
    • DATASET:
    • label (optional)
    • ext
    • path
      • {Convert Json Objects/Arrays to xml nodes, fields to attributes}