public void Export2ExcelWithoutFixedRows(C1FlexGrid i_fg, int i_iFromGridCol, int i_iToGridCol, bool i_b_show)
{
try
{
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
if (!m_init_successful)
{
return;
}
CExportColumnFactory v_objFact = new CExportColumnFactory(i_fg, m_objExcelWorksheet);
IExportColumn v_objExpCol = default(IExportColumn);
int v_iGridCol = 0;
int v_iNumberOfCol = 0;
int v_iVisibleColsCount = 0;
int v_iCount = 0;
// Chen 1 so dong trong Excel tuong ung voi so Ban ghi can insert
Range v_obj_range = m_objExcelWorksheet.Range[m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol], m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol]];
for (v_iCount = i_fg.Rows.Fixed; v_iCount <= i_fg.Rows.Count - 2; v_iCount++)
{
v_obj_range.EntireRow.Insert(Excel.XlDirection.xlDown, null);
}
for (v_iGridCol = i_iFromGridCol; v_iGridCol <= i_iToGridCol; v_iGridCol++)
{
if (i_fg.Cols[v_iGridCol].Visible)
{
v_objExpCol = v_objFact.CreateExportColumn(v_iGridCol, m_iSheetStartCol + v_iNumberOfCol, m_iSheetStartRow);
v_iNumberOfCol++;
v_objExpCol.ExportWithoutFixedRows();
v_iVisibleColsCount++;
}
}
if (m_b_set_style)
{
setStyle4Node(i_fg, v_iVisibleColsCount);
}
m_iSheetStartRow = m_iSheetStartRow + i_fg.Rows.Count;
if (i_b_show)
{
m_objExcelApp.Visible = true; //Not Display Excel
string v_strFilenameWithPath = "";
v_strFilenameWithPath = m_strOutputPath + System.Convert.ToString((long)(VBMath.Rnd() * 1000000000000));
try
{
m_objExcelApp.SaveWorkspace(v_strFilenameWithPath);
}
catch
{
//m_objExcelApp.Workbooks.Close()
Unmount();
return;
}
//m_objExcelApp.Workbooks.Close()
Unmount();
}
}
catch (Exception v_e)
{
m_objExcelApp.Workbooks.Close();
Unmount();
throw (v_e);
}
}
//Huytd
public void Export2ExcelWithoutFixedRows_saveDialog(string str_file_name, C1FlexGrid i_fg, int i_iFromGridCol, int i_iToGridCol, bool i_b_show)
{
try
{
SaveFileDialog saveFileDialog = new SaveFileDialog();
saveFileDialog.Filter = "Execl files (*.xls)|*.xls";
saveFileDialog.FilterIndex = 0;
saveFileDialog.RestoreDirectory = true;
saveFileDialog.CreatePrompt = true;
saveFileDialog.Title = "Export Excel File To";
System.Threading.Thread.CurrentThread.CurrentCulture = System.Globalization.CultureInfo.CreateSpecificCulture("en-US");
if (!m_init_successful)
{
return;
}
CExportColumnFactory v_objFact = new CExportColumnFactory(i_fg, m_objExcelWorksheet);
IExportColumn v_objExpCol = default(IExportColumn);
int v_iGridCol = 0;
int v_iNumberOfCol = 0;
int v_iVisibleColsCount = 0;
int v_iCount = 0;
// Chen 1 so dong trong Excel tuong ung voi so Ban ghi can insert
Range v_obj_range = m_objExcelWorksheet.Range[m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol], m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol]];
v_iCount = i_fg.Rows.Fixed;
while (v_iCount <= i_fg.Rows.Count - 2)
{
v_obj_range.EntireRow.Insert(Excel.XlDirection.xlDown, null);
System.Math.Max(System.Threading.Interlocked.Increment(ref v_iCount), v_iCount - 1);
}
v_iGridCol = i_iFromGridCol;
while (v_iGridCol <= i_iToGridCol)
{
if (i_fg.Cols[v_iGridCol].Visible)
{
v_objExpCol = v_objFact.CreateExportColumn(v_iGridCol, m_iSheetStartCol + v_iNumberOfCol, m_iSheetStartRow);
v_iNumberOfCol++;
v_objExpCol.ExportWithoutFixedRows();
v_iVisibleColsCount++;
}
System.Math.Max(System.Threading.Interlocked.Increment(ref v_iGridCol), v_iGridCol - 1);
}
if (m_b_set_style)
{
setStyle4Node(i_fg, v_iVisibleColsCount);
}
m_iSheetStartRow = m_iSheetStartRow + i_fg.Rows.Count;
if (i_b_show)
{
if (saveFileDialog.ShowDialog() == System.Windows.Forms.DialogResult.OK)
{
m_objExcelApp.Visible = true;
//Not Display Excel
string v_strFilenameWithPath = "";
v_strFilenameWithPath = str_file_name;
m_objExcelApp.SaveWorkspace(v_strFilenameWithPath);
//m_objExcelApp.Workbooks.Close()
Unmount();
}
}
}
catch (Exception v_e)
{
m_objExcelApp.Workbooks.Close();
Unmount();
throw (v_e);
}
}
public void Export2Excel(C1FlexGrid i_fg, int i_iFromGridCol, int i_iToGridCol, bool i_b_show = true)
{
try
{
if (!m_init_successful)
{
return;
}
CExportColumnFactory v_objFact = new CExportColumnFactory(i_fg, m_objExcelWorksheet);
IExportColumn v_objExpCol = default(IExportColumn);
int v_iGridCol = 0;
int v_iNumberOfCol = 0;
int v_iVisibleColsCount = 0;
int v_iCount = 0;
// Chen 1 so dong trong Excel tuong ung voi so Ban ghi can insert
Range v_obj_range = m_objExcelWorksheet.Range[m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol], m_objExcelWorksheet.Cells[m_iSheetStartRow + 1, m_iSheetStartCol]];
for (v_iCount = i_fg.Rows.Fixed; v_iCount <= i_fg.Rows.Count - 2; v_iCount++)
{
v_obj_range.EntireRow.Insert(Excel.XlDirection.xlDown, null);
}
for (v_iGridCol = i_iFromGridCol; v_iGridCol <= i_iToGridCol; v_iGridCol++)
{
if (i_fg.Cols[v_iGridCol].Visible)
{
v_objExpCol = v_objFact.CreateExportColumn(v_iGridCol, m_iSheetStartCol + v_iNumberOfCol, m_iSheetStartRow);
v_iNumberOfCol++;
v_objExpCol.Export();
v_iVisibleColsCount++;
}
}
if (m_b_set_style)
{
setStyle4Node(i_fg, v_iVisibleColsCount);
}
m_iSheetStartRow = m_iSheetStartRow + i_fg.Rows.Count;
if (i_b_show)
{
m_objExcelApp.Visible = true;
Unmount();
}
}
catch (Exception v_e)
{
m_objExcelApp.Workbooks.Close();
Unmount();
throw (v_e);
}
}
