/// <summary>
/// Calculates the next available SheetId for this sheets collection
/// </summary>
/// <param name="sheets">this Sheets instance</param>
/// <returns>The next available id </returns>
public static uint NextAvailableSheetId(this Sheets sheets)
{
uint sheetId = 0;
foreach (var s in sheets.Cast <Sheet>())
{
if (s.SheetId >= sheetId)
{
sheetId = s.SheetId + 1;
}
}
return(sheetId);
}
protected void Unnamed1_Click(object sender, EventArgs e)
{
var un = new ExcelQueryFactory("C:\\Users\\k697344\\Documents\\Libro3.xlsx");
var dos = new ExcelQueryFactory("https://one.web.ppg.com/la/comex/camp_publicidad/DocumentosCampaas/Cronogramas/DatosBDWizard.xlsx");
string url = HttpUtility.HtmlEncode("https://one.web.ppg.com/la/comex/camp_publicidad/DocumentosCampaas/Cronogramas/DatosBDWizard.xlsx");
var excel = new Application();
excel.Visible = false;
string workbookPath = url;
Workbook excelWorkbook = excel.Workbooks.Open(workbookPath, 0, false, 5, "", "", false, XlPlatform.xlWindows, "",
true, false, 0, true, false, false);
excelWorkbook.SaveAs("C:\\Users\\k697344\\Documents\\Libro22.xlsx", Microsoft.Office.Interop.Excel.XlFileFormat.xlWorkbookDefault, Type.Missing,
Type.Missing, true, false, XlSaveAsAccessMode.xlNoChange, XlSaveConflictResolution.xlLocalSessionChanges, Type.Missing, Type.Missing);
excelWorkbook.Close(true, "C:\\Users\\k697344\\Documents\\Libro22.xlsx", false);
excelWorkbook.Close();
Sheets sheets = excelWorkbook.Worksheets;
Worksheet worksheet = sheets.Cast <Worksheet>().Where(n => n.Name == "Hoja1").FirstOrDefault();
//Worksheet worksheet = (Worksheet)sheets.Item[6];
//bool flag = false;
var data2 = worksheet.ListObjects.Cast <Object>().FirstOrDefault();
Range range = worksheet.Range["", ""];
var values = (System.Array)range.Cells.Value2;
var book = new ExcelQueryFactory(workbookPath);
var datos = book.Worksheet(6).AsEnumerable().Select(row => new
{
uno = row["uno"],
dos = row["dos"]
}).ToList();
}
/// <summary>
/// Determines if a sheet already exists by name
/// </summary>
/// <param name="sheets">this Sheets instance</param>
/// <param name="name">Potential sheet name</param>
/// <returns>True if the sheet exists; otherwise, false</returns>
public static bool SheetExists(this Sheets sheets, string name)
{
return(sheets.Cast <Sheet>().Any(s => s.Name.Value.Equals(name, System.StringComparison.OrdinalIgnoreCase)));
}
