Skip to main content

EPPlus : Reading Excel's dynamic worksheets, dynamic rows and dynamic columns

private static void POC_ReadExcelWorksheetsRowsAndColumns()
{
    string excelFile = @"C:\Raw Excel.xlsx";
    using (ExcelPackage package = new ExcelPackage(new FileInfo(excelFile)))
    {
        foreach (ExcelWorksheet workSheet in package.Workbook.Worksheets)
        {
            // Make sure its not a blank sheet:
            if (workSheet.Dimension == null) continue;

            // Get dynamic row and column count:
            int rowCount = workSheet.Dimension.End.Row;
            int columnCount = workSheet.Dimension.End.Column;

            Console.WriteLine("Worksheet name: {0}, with {1} rows and {2} columns", workSheet.Name, rowCount, columnCount);

            Console.WriteLine("workSheet.Dimension.Rows: {0}", workSheet.Dimension.Rows);
            Console.WriteLine("workSheet.Dimension.Columns: {0}", workSheet.Dimension.Columns);
            Console.WriteLine(string.Format("Cell A1 value is {0}", workSheet.Cells["A1"].Value));
        }
    }   
}

Comments

Popular posts from this blog

Alidropship plugins - Da Vince Theme Subscription Fixed using MailChimp

From MailChimp Code: Wrecked the design on the UI <!-- Begin MailChimp Signup Form --> <link href="// cdn-images.mailchimp.com/embedcode/slim-10_7.css " rel="stylesheet" type="text/css"> <style type="text/css"> #mc_embed_signup{background:#fff; clear:left; font:14px Helvetica,Arial,sans-serif;  width:450px;} /* Add your own MailChimp form style overrides in your site stylesheet or in this style block.    We recommend moving this block and the preceding CSS link to the HEAD of your HTML file. */ </style> <div id="mc_embed_signup"> <form action=" https://tester.us19.list-manage.com/subscribe/post?u=5b6e4f12343b19be8f09a2fef&amp;id=aeeef4383c " method="post" id="mc-embedded-subscribe-form" name="mc-embedded-subscribe-form" class="validate" target="_blank" novalidate>     <div id="mc_embed_signup_scroll"> <label for...

Ubuntu 20.04 LTS | Installing OpenJDK 11 (LTS) JDK, JRE, HotSpot

https://adoptopenjdk.net/installation.html#linux-pkg ctrl + f => Linux RPM and DEB installer packages bboy@bboy-LE7450:~$ cat /etc/os-release | grep UBUNTU_CODENAME UBUNTU_CODENAME=focal bboy@bboy-LE7450:~$ sudo apt-get install wget apt-transport-https gnupg [sudo] password for bboy: Reading package lists... Done Building dependency tree       Reading state information... Done wget is already the newest version (1.20.3-1ubuntu1). wget set to manually installed. gnupg is already the newest version (2.2.19-3ubuntu2.1). gnupg set to manually installed. The following packages were automatically installed and are no longer required:   linux-headers-5.8.0-45-generic linux-hwe-5.8-headers-5.8.0-45   linux-image-5.8.0-45-generic linux-modules-5.8.0-45-generic   linux-modules-extra-5.8.0-45-generic Use 'sudo apt autoremove' to remove them. The following NEW packages will be installed:   apt-transport-https 0 upgraded, 1 newly installed, 0 to remove and 21 not upgraded. Need to get 1,...