private void button1_Click_1(object sender, EventArgs e)
{
konversi kon = new konversi();
wsClass ws = new wsClass();
//string str = ws.cekLogin("adminkomdn", "ediimdn");
string str = ws.cekLoginUoi("adminuoi", "adminuoi1");
//string str = kon.strToTxt("5659|9033|2019|9533156626|4|01.01.2019||01.01.2019||996001665|21105542|SODIUM ISETHIONATE AQUEOUS SOLUTION 57%|-14.076.900|261|KG|01.01.2019|AMRULLA_Y500|T73A||03:11:33|||||");
MessageBox.Show(str);
}
public int xlsToTxt(string filePath, string ext)
{
ISheet Sheet = null;
int i = 2;
konversi kon = new konversi();
string pes = "";
try
{
Sheet = fileMan.get_sheet_file_object(filePath, ext);
}
catch (Exception e)
{
Console.WriteLine("1 " + e);
}
int x = 4, k = 0, rowcount = 1;
string kal = "";
while (i <= Sheet.LastRowNum)
{
try
{
IRow row = Sheet.GetRow(i);
if (row == null)
{
kal = "";
}
else
{
int mul = 26 - row.LastCellNum;
ICell c = row.GetCell(15);
if (c != null)
{
if (c.ToString() == "261")
{
for (k = 2; k < row.LastCellNum; k++)
{
c = row.GetCell(k);
if (c == null)
{
kal = kal + "|";
}
else
{
kal = kal + c.ToString().Trim() + "|";
}
}
kal = kal + Tabs(mul);
rowcount++;
}
}
}
}catch (Exception e)
{
Console.WriteLine("2 " + e);
kal = "";
}
if (kal != "")
{
Console.WriteLine(rowcount + " " + kal);
pes = kon.strToTxt(kal);
}
kal = "";
i++;
}
return(rowcount);
}