epplus
How to create a link inside a cell using EPPlus
I a开发者_如何学运维m trying to figure out how to write a Hyperlink inside a cell using EPPlus instead of the cell containing the link text. I need it to be recognized as a link and be clickable.[详细]
2023-04-10 23:48 分类:问答{Property evaluation failed.} when exporting data to excel in vb.net
I am using the code below to export records in a datatable to an excel file using EPPlus. Dim excelPackage = New ExcelPackage[详细]
2023-04-10 01:03 分类:问答EPPlus 2.9.0.1 throws System.IO.IsolatedStorage.IsolatedStorageException when trying to save a file bigger than ~1.5 MiB from a SSIS package
The problem When I try to save a file over ~1.5 MiB with EPPlus ExcelPackage.Save() throws a System.IO.IsolatedStorage.IsolatedStorageException.[详细]
2023-04-06 09:17 分类:问答Filter a DateTime field for year,month and day in excel pivot
I\'m using EPPlus to create Excel reports. Now i\'m trying to create a Pivot with a DateTime PageField, so that the user can filter the period he want to see by himself. But although i can filter thi[详细]
2023-04-03 22:21 分类:问答How do I find the extents of my data in an Excel file (.XLSX) using EPPlus?
Given an Excel spreadsheet, how do I find the extents of the data? Is there a method I can call or a property I can check? Do I need to check cell-by-cell for nulls and then row-by-row? There\'s gotta[详细]
2023-02-09 13:34 分类:问答C# -Interview Question Anonymous Type
Recently i was asked to prove the power of C# 3.0 in a single line( might be tricky) i wrote new int[] { 1, 2, 3 }.Union(new int[]{10,23,45}).[详细]
2022-12-27 02:37 分类:问答