Tag Archives: antic

[Solved] Jxls error: Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath

Note the problems encountered in using Jxls in the project

Cannot load XLS transformer. Please make sure a Transformer implementation is in classpath

Check whether components such as easyexcel are introduced into the project
if so, it needs to be excluded

<dependency>
      <groupId>com.alibaba</groupId>
      <artifactId>easyexcel</artifactId>
      <version>2.2.10</version>
      <exclusions>
        <exclusion>
          <artifactId>poi</artifactId>
          <groupId>org.apache.poi</groupId>
        </exclusion>
        <exclusion>
          <artifactId>poi-ooxml</artifactId>
          <groupId>org.apache.poi</groupId>
        </exclusion>
        <exclusion>
          <artifactId>poi-ooxml-schemas</artifactId>
          <groupId>org.apache.poi</groupId>
        </exclusion>
      </exclusions>
    </dependency>

Then
the POI component 4 version is introduced

    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi</artifactId>
      <version>4.1.2</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml</artifactId>
      <version>4.1.2</version>
    </dependency>
    <dependency>
      <groupId>org.apache.poi</groupId>
      <artifactId>poi-ooxml-schemas</artifactId>
      <version>4.1.2</version>
    </dependency>

Because the project is iterative, complex excel is exported. Easyexcel can not meet the requirements. You can consider processing complex logic in the form of Jxls template.
it can solve the function of Excel processing by block, horizontal and column
official website: http://jxls.sourceforge.net/

In theory, it is not recommended to use several excel components at the same time. The idea plug-in Maven helper is recommended here to facilitate conflict handling.

When a problem is inexplicable and can not be solved by how to change it, see if there is a package conflict and if there is a problem with the network itself.

ERROR bag unindexed: 2021-6-23-0103all.bag. Run rosbag reindex.

1. Problem
if you want to run a. Bag file that hasn’t been used for a long time, run the command: rosbag info XXX. Bag , and find an error, as follows:

ERROR bag unindexed: 2021-6-23-0103all.bag.  Run rosbag reindex.

If you want to play it by force: rosbag play XXX. Bag , you can’t either. The error is as follows:

 [ INFO] [1624972506.447439941]: Opening 2021-6-23-0103all.bag
[FATAL] [1624972506.448068825]: Error reading from file: wanted 4 bytes, read 0 bytes

2. Solution
according to the error prompt, enter the command:

rosbag reindex xxx.bag

Two. Bag files will be generated, as follows:

in the picture, xx.orig.bag is the first package, and xxx.bag is the package after reindex.
finally, enter the command: rosbag info XXX. Bag to output normally, as follows: