Thursday, October 17, 2019

Unlock protect sheet xlsx

1 rename xlsx to zip
> ren protect.xlsx protect.zip
2 In zip goto xl  --> worksheets
3 unzip sheetx.xml tofix it (outside zip)
4 open sheetx.xml and search "protect"
5 remove

example


6 put all remove protect back to zip
7 rename zip to xlsx

Finish

Cr.
http://www.excelsupersite.com

http://www.excelsupersite.com/how-to-remove-an-excel-spreadsheet-password-in-6-easy-steps/

Monday, October 7, 2019

Create Jar include dependencies and run

'    <project xmlns="http://maven.apache.org/POM/4.0.0" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://maven.apache.org/POM/4.0.0 http://maven.apache.org/xsd/maven-4.0.0.xsd">
    <modelVersion>4.0.0</modelVersion>
    <groupId>com.matco</groupId>
    <artifactId>pdfcutter</artifactId>
    <version>1.0-SNAPSHOT</version>
    <packaging>jar</packaging>
    <dependencies>
        <dependency>
            <groupId>com.itextpdf</groupId>
            <artifactId>itextpdf</artifactId>
            <version>5.5.13.2</version>
        </dependency>
    </dependencies>
    <properties>
        <project.build.sourceEncoding>UTF-8</project.build.sourceEncoding>
        <maven.compiler.source>8</maven.compiler.source>
        <maven.compiler.target>8</maven.compiler.target>
    </properties>
    <build>
  <plugins>
    <plugin>
      <artifactId>maven-assembly-plugin</artifactId>
      <configuration>
        <archive>
          <manifest>
            <mainClass>com.matco.pdfcutter.Pdfcutter</mainClass>
          </manifest>
        </archive>
        <descriptorRefs>
          <descriptorRef>jar-with-dependencies</descriptorRef>
        </descriptorRefs>
      </configuration>
    </plugin>
  </plugins>
</build>
</project>
'     
'       
'          maven-assembly-plugin
'         
'           
'             
'                com.matco.pdfcutter.Pdfcutter
'             
'           
'           
'              jar-with-dependencies
'           
'         
'       
'     
'   
after build
@folder project
example c:/..../Pdfcutter/
cmd mvn clean compile assembly:single

Mvn must download and install


'   
'        UTF-8
'        1.8
'        1.8
'   

for MVN compile to collect version