Read vale from checkbox from excel sheet

first post: mariusz695 wrote: Hello, can someone tell me how I can read value from checkbox and ...

How to Select data from excel using column header in closedXML

first post: saneeshkunjunni wrote: Iam using this code for retrieve data from worksheet but i not able...

Detecting Hidden Rows / Columns / Cells

first post: DaveEP wrote: I've been given the task of importing several Excel files on a regu...

Filter on Text Color

first post: SteveMets2 wrote: Hi, It's been a while since I had a question, but this may be som...

latest post: SteveMets2 wrote: Also, I have this working: if (row.Cell(2).Style.Font....

Styles

first post: DeimonAx wrote: Something wrong is happening I create a range and procedure to se...

How to get just cell value?

first post: ParkSangJoon wrote: I want to get just cell value. nothing anymore just get value? H...

answered by: ParkSangJoon wrote: I want to get just cell value. nothing anymore just get value? H...

Custom DataValidation

first post: tibox8 wrote: Hello I try to used the custom datavalidation var validate = wor...

DateTime is one day off

first post: jesta1215 wrote: Greetings, I'm trying to write a datetime to a cell using Closed...

File size increase when updating a file

first post: SimonPrice33 wrote: I have a file that its original size is 68KB, using ClosedXML to op...

latest post: cgalerac wrote: I have the same problem. Any solution?

Any easy way to format a particular column to be 'number' instead of 'text' when converting a dataset into xls ?

first post: punkouter wrote: static void CreateExcelFromDataTable(DataTable dtExcel, string spN...