liugddx opened a new issue, #746: URL: https://github.com/apache/fesod/issues/746
### Search before asking - [x] I searched in the [issues](https://github.com/apache/fesod/issues) and found nothing similar. ### Motivation ## Summary Develop a command-line interface tool for Apache Fesod to enable spreadsheet processing without writing code, supporting format conversion, data extraction, and batch operations. ## Motivation Users need a CLI tool to: - Convert spreadsheet formats quickly (xlsx ↔ xls ↔ csv ↔ ods) - Extract data to JSON/CSV for pipelines - Process files in shell scripts and CI/CD - Use Fesod without Java programming ## Proposed Commands ``` # Read and output as JSON fesod read data. xlsx --format json --sheet 0 # Convert formats fesod convert input.xls output.xlsx # Write from JSON/CSV fesod write data. json output.xlsx --input-format json # Show file info fesod info data. xlsx ``` Key Options - --format <json|csv|xml>: Output format - --sheet <name|index>: Specify sheet - --output <file>: Output file path - --config <file>: Use config file ## Technical Approach ### Stack - CLI Framework: [picocli](https://picocli.info/) - Build: Maven assembly plugin for executable JAR - Java: 8+ compatible ### Project Structure ``` fesod-cli/ ├── src/main/java/org/apache/fesod/cli/ │ ├── FesodCli.java │ ├── commands/ │ │ ├── ReadCommand.java │ │ ├── WriteCommand.java │ │ ├── ConvertCommand.java │ │ └── InfoCommand.java │ └── formatters/ │ ├── JsonFormatter.java │ └── CsvFormatter.java └── pom.xml ``` ### Configuration Support YAML config file (~/.fesod/config.yaml): ``` defaults: output_format: json encoding: UTF-8 read: auto_trim: true ignore_empty_rows: true ``` ### Solution _No response_ ### Alternatives _No response_ ### Anything else? _No response_ ### Are you willing to submit a PR? - [ ] I'm willing to submit a PR! -- This is an automated message from the Apache Git Service. To respond to the message, please log on to GitHub and use the URL above to go to the specific comment. To unsubscribe, e-mail: [email protected] For queries about this service, please contact Infrastructure at: [email protected] --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
