XLS and XLSX Data Sources - 8.2.0 - Jaspersoft Community

Jump to content

This documentation is an older version of JasperReports Server Administration Guide. View the latest documentation.

Overview of JasperReports Server Administration
Overview of Organizations
- Single Default Organization
- Multiple Organizations
- Levels of Administrators
Overview of the Repository
- Folder Structure
- Resources
- Browsing and Searching
Overview of Users and Roles
- Administering Users and Roles
- Delegated Administration
Overview of Security
Administrator Login
- JasperReports Server Heartbeat
- Administrator Email
Administrator Pages
User and Role Management
- Managing Organizations
- Managing Users
- Managing Roles
- Managing Attributes
Repository Administration
- Resource Types
- JasperReport Structure
- Managing Folders and Resources
- Multiple Organizations in the Repository
- Repository Permissions
Data Sources
- Attributes in Data Source Definitions
- JDBC Data Sources
- Managing JDBC Drivers
- JNDI Data Sources
- AWS Data Sources
- Azure SQL Data Sources
  - Uploading an Azure Certificate File to the Repository
  - Creating an Azure SQL Server Data Source
- Snoflake Data Sources
- Hadoop-Hive Data Sources
- MongoDB Data Sources
- Virtual Data Sources
- TIBCO Data Virtualization
- XLS and XLSX Data Sources
- File Data Sources
- Bean Data Sources
Other Resources in the Repository
- Queries
- Datatypes
- Lists of Values
- Input Controls
- Query-based Input Controls
- Cascading Input Controls
  - Parameters in Input Control Queries
  - Creating a Cascading Input Control
- File Resources
Themes
- Introduction to Themes
- How Themes Work
- Administering Themes
- Creating Themes
- Working With CSS Files
Admin Console
- Schedules
- Alerts
- Diagnostics
Import and Export
- Import and Export Catalogs
- Dependencies During Import and Export
- The Import-Export Encryption Keys
- Import and Export Through the Web UI
- Import and Export Through the Command Line
- Alternate Import-Export Scripts
  - Running Import from Buildomatic
  - Running Export from Buildomatic
System Configuration
- Configuration Settings in the User Interface
- Configuration for Using Proxies
- Configuration for Session Persistence
- Enabling Compression in Tomcat
- Configuring Ad Hoc
- Enabling Data Snapshots
- Enabling Data Staging
- Configuring Cloud Services
- Configuring Domains
- Configuring JasperReports Library
- Disabling Open In Editor Option
- Configuring Input Control Behavior
- Configuring the Scheduler
- Configuring Report Thumbnails
- Configuring the Heartbeat
- Configuring the Online Help
OpenTelemetry
- Usecases
- Configuring OpenTelemetry and Jaegar Agent
Server Diagnostics
- Configuring System Logs
- Using Log Collectors
- Auditing and Monitoring Events
- Configuring Auditing and Monitoring
- Using the Audit Data
  - Audit Domain Items
  - Audit Reports and Ad Hoc Views
- Using the Monitoring Data
  - Monitoring Domain Items
  - Monitoring Reports and Ad Hoc Views
- Importing and Exporting Event Data
- Real-Time Diagnostics
- Exposing Diagnostics Through Jaspersoft’s JMX Agent
- Using the Diagnostic Data in Reports
- Excluding Diagnostic Attributes
- Disabling Real-Time Diagnostics
- Server Monitoring
Troubleshooting
- Number of Users Exceeded
- Running Out of Database Connections
- Data Chooser is Slow
- Fields Not Listed in Ad Hoc Editor
- Field Names Disappear in Ad Hoc Editor
- Ad Hoc Filter With All Values Causing Error
- Ad Hoc Dimensions Too Large
- Custom URLs Not Loading in Dashboards
- Print View Not Displaying in Dashboards
- Scheduler Sending Multiple Emails
- Scheduler Not Sending STARTTLS Emails
- Scheduler Running Deleted Jobs
- Scheduler Timezones in Excel Output
- Charts Not Appearing in Excel Export
- Working With Data Sources
  - Logging JDBC Operations
  - JDBC Drivers
  - Database Permissions
  - Unique JDBC Data Source Fields
  - JDBC Database URLs
  - SQL Functions with TIBCO JDBC Drivers
  - Enabling the TIBCO JDBC Drivers for Impala and Cassandra Data Sources
  - Enabling the JDBC Driver for ElasticSearch Data Sources
  - JNDI Services on Apache Tomcat
  - JNDI Services on JBoss
  - JNDI Services on WebLogic
  - Creating a Data Source on SQL Server Using Windows Authentication
  - Upgrading Bean Data Sources
- Special Characters in Database Schemas
- Hadoop-Hive Reports Not Running
- Cassandra Reports Not Running
- Maximum Parameter Size in Wildfly
- Extra Comma Appearing in Time Stamp
- Extra Comma Appearing in Time Stamp
Localization
- Configuring JasperReports Server for Multibyte Fonts
- UTF-8 Configuration
  - Java Options
  - Tomcat
  - PostgreSQL
  - MySQL
  - Oracle
- Changing Character Encoding
- Creating a Locale
- Configuring JasperReports Server to Offer a Locale
Glossary
About This Guide

XLS and XLSX Data Sources

XLS and XLSX data sources read a file in the Microsoft Excel XLS or XLSX format and allow you to query its contents as a relational table. These data sources support features Domain-related features like returning JDBC metadata, creating derived tables, supporting calculated fields, Domain pre-filtering, joining other data sources in a virtual data source, and full support in the Domain Designer.

To create an XLS or XLSX data source:

1.

Log on as an administrator.

2.

Click View > Repository, expand the folder tree, and right-click a folder to select Add Resource > Data Source from the context menu. Alternatively, you can select Create > Data Source from the main menu on any page and specify a folder location later. If you installed the sample data, the suggested folder is Data Sources. The New Data Source page appears.

3.

In the Type field, select either the XLS or XLSX Data Source. In this example, we create an XLSX data source.

File Data Source Page for an XLS/XLXS Data Source

4.

Enter the date and time format patterns used for the data source.

5.

Enter the file path for the XLSX file. You can specify a file in the repository with the repo: syntax, followed by the repository path of the file. Specify ftp:, http: or https: to use those Internet protocols. To specify a file on your server's file system, specify its path directly, starting from the root, for example /tmp/MyDataFile.xlsx. The user running the server process must have permission to access the file.

Note: Only the File Path field is required, and the remaining fields are optional.

6.

Enter the regional locale for the file. The locale property displays the data in a specific format based on the region. (optional)

7.

Enter the number pattern for the file. (optional)

8.

Enter the name of the Excel file sheet to use for the data source. (optional)

9.

Enter the local time zone for the file. (optional)

10.

Specify whether the first row in the XLSX file is a header as true or false. (optional)

11.

Click Save. The Save dialog appears.

12.

Enter a name for the data source and an optional description. The Resource ID is generated from the name you enter. If you haven't already specified a location, expand the folder tree and select the location for your data source.

13.

Click Save in the dialog. The data source appears in the repository.

Share

Go to documents

User Feedback

0 Comments

Recommended Comments

There are no comments to display.

×

×

Create New...