File APIs for Word/Excel/PowerPoint/PDF

Excel data validation is useful when a worksheet is meant to be filled in by other people. Instead of accepting any value, a cell can be limited to a number range, a date period, a certain text length, or a predefined list of choices. This is especially helpful for forms and reusable templates, where inconsistent input can create extra cleanup work later. In this tutorial, we’ll add several common validation rules to an Excel worksheet with Java, including whole number, date, text length, list, and time validation. Common Excel Data Validation Types Excel supports several validation types for different kinds of input: Validation Type Typical Use Whole number Quantities, counts, IDs Decimal Prices, percentages, measurements List Status, department, category Date Deadlines, submission dates, schedules Time Appointments, shifts, working hours Text length Codes, abbreviations, identifiers Most rules are built from three parts: the allowed data type, a comparison operator, and one or two li...

Word documents often use tables to store structured information such as inventory lists, inspection records, project data, and reports. Extracting one table manually is simple enough, but it quickly becomes tedious when a document contains several tables or when many Word files need to be processed. With Python, you can read the rows and cells of a Word table and convert the content into a structure that is easier to reuse or export. This guide covers how to read a table from a Word document, extract all tables to CSV files, and process multiple Word files in a folder. Environment Setup To run the examples below, install the required Python module for Word processing: pip install Spire.Doc Read a Table from a Word Document A Word table can be accessed through its section and then read row by row. The example below reads the first table in the first section and stores its content in a two-dimensional Python list: from spire.doc import * from spire.doc.common import * input_file...