By Default we can able to see only 65536 rows in a New Excel work book in Excel 2007. But according to MSDN, we should be able to see 1 million (10Lakh) rows in Excel 2007. To utilize the maximum, open a new work book save as Excel format (XLSX). Now important think is Close and reopen the book, you can able to see more than 1 million rows in that.
Subscribe to:
Post Comments (Atom)
-
Powershell - CURL error Ambiguous parameters in the command : I tried to invoke bitbucket pipelines from API using CURL command. I installe...
-
Today, while I am solving a old script, I need to remove a comma at the end in a string which is feed to construct a dynamic url in a reque...
-
Configure an application to use Fiddler Fiddler is an HTTP Proxy running on port 8888 on your local PC. You can configure any appli...
No comments:
Post a Comment