protected void Button4_Click(object sender, EventArgs e)
{
string excelFilePath = @"\\192.168.198.8\Documents\alyajlar.xlsx";
System.IO.FileInfo file = new System.IO.FileInfo(excelFilePath);
if (file.Exists)
{
FarPoint.Web.Spread.FpSpread fpSpread1 = new FarPoint.Web.Spread.FpSpread();
FarPoint.Web.Spread.SheetView shv = new FarPoint.Web.Spread.SheetView();
Controls.Add(fpSpread1);
// fpSpread1.Sheets.Add(shv);
string fileName;
fileName = excelFilePath;
//fpSpread1.OpenExcel(fileName);
//FpSpread1.OpenExcel(fileName, FarPoint.Excel.ExcelOpenFlags.NoFlagsSet);
FpSpread1.OpenExcel(@"\\192.168.198.8\Documents\alyajlar.xlsx", FarPoint.Excel.ExcelOpenFlags.NoFlagsSet);
FpSpread1.ActiveSheetView.PageSize = FpSpread1.Rows.Count;
}
else
{
MessageBox.Show("Yuklenecek Dosyayı Seçin...", MessageBox.MesajTipleri.Error, false, 5);
}
//if (FileUpload1.PostedFile.FileName != "")
//{
// try
// {
// appdirname = Request.ApplicationPath;
// pathname = HttpContext.Current.Server.MapPath(Request.ApplicationPath);
// OpenExcelFile("Documents\\"+ FileUpload1.PostedFile.FileName);
// FpSpread1.Sheets[0].PageSize = 20;
// FpSpread1.Sheets[0].AllowPage = false;
// }
// catch (IOException ex)
// {
// // Label1.Text = "dosya yok";
// }
//}
// else
//{
// MessageBox.Show("Yuklenecek Dosyayı Seçin...", MessageBox.MesajTipleri.Error, false, 5);
//}
}
//barath 03.03.17
// headername = "S.No-50/Transfer Date-100/Item Code-150/Item Name-150/Transfer From-200/Transfer To-200/Transfer Quantity-100";
public void Fpreadheaderbindmethod(string headername, FarPoint.Web.Spread.FpSpread spreadname, string AutoPostBack)
{
try
{
string[] header = headername.Split('/');
int k = 0;
if (AutoPostBack.Trim().ToUpper() == "TRUE")
{
if (header.Length > 0)
{
spreadname.Sheets[0].RowCount = 0;
spreadname.Sheets[0].ColumnCount = 0;
spreadname.CommandBar.Visible = false;
spreadname.Sheets[0].AutoPostBack = true;
spreadname.Sheets[0].ColumnHeader.RowCount = 1;
spreadname.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
spreadname.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
foreach (string head in header)
{
k++;
spreadname.Sheets[0].ColumnCount = Convert.ToInt32(header.Length);
if (head.Trim().ToUpper() == "S.NO")
{
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Text = head;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Bold = true;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].HorizontalAlign = HorizontalAlign.Center;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Name = "Book Antiqua";
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Size = FontUnit.Medium;
spreadname.Columns[k - 1].Width = 50;
}
else
{
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Text = head;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Bold = true;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].HorizontalAlign = HorizontalAlign.Center;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Name = "Book Antiqua";
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Size = FontUnit.Medium;
spreadname.Columns[k - 1].Width = 200;
}
}
}
}
else if (AutoPostBack.Trim().ToUpper() == "FALSE")
{
if (header.Length > 0)
{
spreadname.Sheets[0].RowCount = 0;
spreadname.Sheets[0].ColumnCount = 0;
spreadname.CommandBar.Visible = false;
spreadname.Sheets[0].AutoPostBack = false;
spreadname.Sheets[0].ColumnHeader.RowCount = 1;
spreadname.Sheets[0].RowHeader.Visible = false;
FarPoint.Web.Spread.StyleInfo darkstyle = new FarPoint.Web.Spread.StyleInfo();
darkstyle.BackColor = ColorTranslator.FromHtml("#0CA6CA");
darkstyle.ForeColor = Color.White;
spreadname.ActiveSheetView.ColumnHeader.DefaultStyle = darkstyle;
foreach (string head in header)
{
k++;
string[] width = head.Split('-');
spreadname.Sheets[0].ColumnCount = Convert.ToInt32(header.Length);
if (Convert.ToString(width[0]).Trim().ToUpper() == "S.NO")
{
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Text = Convert.ToString(width[0]);
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Bold = true;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].HorizontalAlign = HorizontalAlign.Center;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Name = "Book Antiqua";
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Size = FontUnit.Medium;
spreadname.Columns[k - 1].Width = Convert.ToInt32(width[1]);
}
else
{
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Text = Convert.ToString(width[0]);
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Bold = true;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].HorizontalAlign = HorizontalAlign.Center;
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Name = "Book Antiqua";
spreadname.Sheets[0].ColumnHeader.Cells[0, k - 1].Font.Size = FontUnit.Medium;
spreadname.Columns[k - 1].Width = Convert.ToInt32(width[1]);
}
}
}
}
}
catch (Exception ex)
{
}
}
