In this method, you can use the Insert tab to insert the Excel spreadsheet data into a Word document. The screenshot below shows that Excel spreadsheet data is inserted into the Word document. Right-click on the document and click on the Paste option, or you can simply press the Ctrl+V key from the keyboard to paste the data highlighted data in the Word document. Open the Word document and place the cursor in the document where you want to copy the Excel data.Ĥ. Right-click on the document and then click the Copy button or press the Ctrl+C key to copy the highlighted data.ģ. Press Ctrl+A key from the keyboard to highlight all cells present in the spreadsheet.Ģ. Open the Excel sheet and highlight the cells that you want to move to the Word document. In Microsoft Word, you can follow the below methods to insert an Excel spreadsheet into a Word document -Ĭopy/Paste is a fast and easy way to insert the Excel data into a Word document.ġ.
#How to add password for excel file how to
Otherwise you need to add the poi-VERSION.jar and poi-ooxml-VERSION.jar to the project’s classpath.You can download the full source code under the Attachments section below.Next → ← prev How to insert an Excel spreadsheet into a Word documentĪs we all know, Microsoft Office is a software product of Microsoft, so it allows you to do a variety of tasks, including handing accounting books, adding graphs or pie charts, inserting excel data into Word, and some more tasks.
Public class Excel2003PasswordReaderExample Maven dependency for Apache POI:If you are using Maven, add the following XML snippet to project’s pom.xml file (3.15 is the latest version of Apache POI when this article is being written):
* This program illustrates how to read a password-protected Excel document Workbook workbook = new HSSFWorkbook(fileSystem) Then you can proceed reading as regular Excel file.Here’s the content of an Excel 2003 document which is protected with password ‘nimda’: And the following is code of a small program that reads content of the first sheet in the above Excel document: package Reading Password-protected Excel 2003 Document (XLS)To open an Excel 2003 document which is secured by a password at the document level, use the following statement before opening a Workbook: tCurrentUserPassword(String password) So the code will look something like this: NPOIFSFileSystem fileSystem = new NPOIFSFileSystem(new File("."), true) ītCurrentUserPassword(".") There’s a slightly difference between reading password-protected Excel 2003 and Excel 2007 formats, but the WorkbookFactory makes things simple.Now, let’s explore the details. This Java tutorial shows you how to read a password-protected Microsoft Excel file using Apache POI - a Java library dedicated for manipulating Microsoft Office documents.
0 kommentar(er)
