public static MExcelDataChunk ReadXLS(string sPathData, string sSheetName)
{
string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" + sPathData + ";";
string yourQuery = "SELECT * FROM [" + sSheetName + "$]";
OdbcConnection oCon = new OdbcConnection(con);
OdbcCommand oCmd = new OdbcCommand(yourQuery, oCon);
DataTable dtYourData = new DataTable("YourData");
oCon.Open();
OdbcDataReader rData = oCmd.ExecuteReader();
dtYourData.Load(rData);
rData.Close();
oCon.Close();
string[,] str = new string[dtYourData.Rows.Count, dtYourData.Columns.Count];
if (dtYourData.Rows.Count <= 0)
return null;
for (int i = 0; i < dtYourData.Rows.Count; i++)
{
for (int j = 0; j < dtYourData.Columns.Count; j++)
str[i,j] = dtYourData.Rows[i][dtYourData.Columns[j].ColumnName].ToString();
}
MExcelDataChunk chunk = new MExcelDataChunk(str, dtYourData.Columns.Count, dtYourData.Rows.Count);
return chunk;
}
void ConvertButton()
{
if (!GUI.Button(rtCreateButton, "Convert"))
{
return;
}
if (sOutput.Equals("in resources folder ex) 0_Commons/DataTable.cs") ||
sPath.Equals("in resources folder ex) 0_Excels/data.xls") ||
sSheetName.Equals("ex) Sheet1"))
{
return;
}
chunkData = MExcelParser.ReadXLS(sBasePath + sPath, sSheetName);
ParsingScript();
}
public static MExcelDataChunk ReadXLS(string sPathData, string sSheetName)
{
string con = "Driver={Microsoft Excel Driver (*.xls)}; DriverId=790; Dbq=" + sPathData + ";";
string yourQuery = "SELECT * FROM [" + sSheetName + "$]";
OdbcConnection oCon = new OdbcConnection(con);
OdbcCommand oCmd = new OdbcCommand(yourQuery, oCon);
DataTable dtYourData = new DataTable("YourData");
oCon.Open();
OdbcDataReader rData = oCmd.ExecuteReader();
dtYourData.Load(rData);
rData.Close();
oCon.Close();
string[,] str = new string[dtYourData.Rows.Count, dtYourData.Columns.Count];
if (dtYourData.Rows.Count <= 0)
{
return(null);
}
for (int i = 0; i < dtYourData.Rows.Count; i++)
{
for (int j = 0; j < dtYourData.Columns.Count; j++)
{
str[i, j] = dtYourData.Rows[i][dtYourData.Columns[j].ColumnName].ToString();
}
}
MExcelDataChunk chunk = new MExcelDataChunk(str, dtYourData.Columns.Count, dtYourData.Rows.Count);
return(chunk);
}
void ConvertButton()
{
if (!GUI.Button(rtCreateButton, "Convert"))
return;
if (sOutput.Equals("in resources folder ex) 0_Commons/DataTable.cs")
|| sPath.Equals("in resources folder ex) 0_Excels/data.xls")
|| sSheetName.Equals("ex) Sheet1"))
return;
chunkData = MExcelParser.ReadXLS(sBasePath + sPath, sSheetName);
ParsingScript();
}
