private static void Main(string[] args) {
var cmd=new CommandParser(args);
var r = InitConfig(cmd);
if (r) {
Xls2MarkDown(cmd);
}
}
private static void Xls2MarkDown(string[] args)
{
int ret = 1;
var cmd = new CommandParser(args);
do
{
if (cmd["t"] != null && cmd["t"] == "md")
{
if (cmd["xls"] == null)
{
break;
}
var xls = cmd["xls"];
var sheet = cmd["sheet"];
var output = Path.Combine(Path.GetDirectoryName(xls), Path.GetFileNameWithoutExtension(xls));
if (!File.Exists(xls))
{
Console.WriteLine("xls file is not exist:{0}", xls);
break;
}
if (sheet != null)
{
var table = xls.ToMd(sheet);
var tableFile = output + table.Name + ".md";
File.WriteAllText(tableFile, table.Value);
Console.WriteLine("Output File: {0}", tableFile);
}
else
{
var tables = xls.ToMd();
foreach (var table in tables)
{
var tableFile = output + table.Name + ".md";
File.WriteAllText(tableFile, table.Value);
Console.WriteLine("Output File: {0}", tableFile);
}
}
ret = 0;
}
} while (false);
if (ret != 0)
{
Console.WriteLine();
Console.WriteLine("Usecase:exceltk -t md -xls xlsfile [-sheet sheetname]");
}
//Console.Read();
}
private static bool InitConfig(CommandParser cmd) {
// default
Config.DecimalPrecision = 0;
if (cmd["t"]!=null){
if (cmd["t"] == "md"){
if (cmd["p"]!=null) {
int precision = 0;
Int32.TryParse(cmd["p"],out precision);
if (precision > 10) {
Console.WriteLine("presision too larger:"+precision);
return false;
}
if(precision>0){
Config.DecimalPrecision=precision;
}
}
}
}
return true;
}
private static void Xls2MarkDown(CommandParser cmd) {
int ret=1;
#if OS_WINDOWS
var allocConsole = false;
#endif
do {
if (cmd["t"]!=null) {
if (cmd["t"] == "md") {
#if OS_WINDOWS
if (!AttachConsole(-1)) {
AllocConsole();
allocConsole = true;
}
#endif
if (cmd["xls"] == null) {
break;
}
string xls = cmd["xls"];
string sheet = cmd["sheet"];
string root = Directory.GetCurrentDirectory();
xls = Path.Combine(root, xls);
string dirName = Path.GetDirectoryName(xls);
string fileName = Path.GetFileNameWithoutExtension(xls);
if(dirName!=null&&fileName!=null){
string output=Path.Combine(dirName, fileName);
if (!File.Exists(xls)) {
Console.WriteLine("xls file is not exist:{0}", xls);
break;
}
if (sheet!=null) {
MarkDownTable table=xls.ToMd(sheet);
string tableFile=output+table.Name+".md";
File.WriteAllText(tableFile, table.Value);
Console.WriteLine("Output File: {0}", tableFile);
} else {
IEnumerable<MarkDownTable> tables=xls.ToMd();
foreach (MarkDownTable table in tables) {
string tableFile=output+table.Name+".md";
File.WriteAllText(tableFile, table.Value);
Console.WriteLine("Output File: {0}", tableFile);
}
}
ret=0;
Console.WriteLine("Done!");
}else{
Console.WriteLine("ERROR: xls path is valid:{0}",xls);
}
} else if (cmd["t"] == "cm") {
#if OS_WINDOWS
Application.Run(new ClipboradMonitor());
#endif
ret = 0;
} else {
// Ignore
}
}
} while (false);
if (ret!=0) {
Console.WriteLine();
Console.WriteLine("Usecase:");
Console.WriteLine("1. Convert xls to markdown: exceltk -t md -xls xlsfile [-sheet sheetname]");
Console.WriteLine("2. Monitor and convert clipboard to markdown: exceltk -t cm");
}
#if OS_WINDOWS
SendKeys.SendWait("{ENTER}");
if (allocConsole) {
FreeConsole();
}
System.Environment.Exit(0);
#endif
}