/ - Diff - Plateforme TXM - Forge du Centre Blaise Pascal

     source.. = src/
     output.. = bin/
     bin.includes = META-INF/,\
+                   .
                    .,\
                    lib/commons-codec-1.10.jar,\
                    lib/commons-collections4-4.1.jar,\
                    lib/commons-logging-1.2.jar,\
                    lib/curvesapi-1.04.jar,\
                    lib/junit-4.12.jar,\
                    lib/log4j-1.2.17.jar,\
                    lib/ooxml-schemas-1.3.jar,\
                    lib/poi-3.17.jar,\
                    lib/poi-excelant-3.17.jar,\
                    lib/poi-ooxml-3.17.jar,\
                    lib/poi-ooxml-schemas-3.17.jar,\
                    lib/poi-scratchpad-3.17.jar,\
                    lib/xmlbeans-2.6.0.jar
     qualifier=svn

     Bundle-Version: 1.0.0.qualifier
     Automatic-Module-Name: org.txm.libs.msoffice
     Bundle-RequiredExecutionEnvironment: JavaSE-1.8
     Bundle-ClassPath: lib/commons-codec-1.10.jar,
      lib/commons-collections4-4.1.jar,
      lib/commons-logging-1.2.jar,
      lib/curvesapi-1.04.jar,
      lib/junit-4.12.jar,
      lib/log4j-1.2.17.jar,
      lib/ooxml-schemas-1.3.jar,
      lib/poi-3.17.jar,
      lib/poi-excelant-3.17.jar,
      lib/poi-ooxml-3.17.jar,
      lib/poi-ooxml-schemas-3.17.jar,
      lib/poi-scratchpad-3.17.jar,
      lib/xmlbeans-2.6.0.jar,
+     .

     import org.txm.core.preferences.TXMPreferences;
     public class GroovyPreferences extends TXMPreferences {
     	public static final String PREFERENCES_NODE = GroovyPreferences.class.getName();//FrameworkUtil.getBundle(RPreferences.class).getSymbolicName();
     	@Override
     	public void initializeDefaultPreferences() {
     		super.initializeDefaultPreferences();
     		// TODO Auto-generated method stub
+    	}
+    }

     import org.txm.edition.rcp.editors.*
     /*
     script = """sheet.insertRule("#w_a01_390 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_470 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_262 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_289 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_421 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_213 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_166 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_342 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_546 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_589 {background-color:rgba(249,208,208,1.0);}", 1);
     sheet.insertRule("#w_a01_504 {background-color:rgba(249,160,160,1.0);}", 1);
     sheet.insertRule("#w_a01_637 {background-color:rgba(249,208,208,1.0);}", 1);
     */
     script = """
     //alert(sheet.cssRules[0].selectorText);
     //alert(sheet.cssRules[0].style.cssText);
     //alert(sheet.cssRules[0].style.length);
     //alert(sheet.cssRules[0].style.parentRule);
     for (var i=0; i < document.styleSheets.length; i++){
     	var styleSheet = document.styleSheets[i];
     	alert(styleSheet.cssRules.length)
     /*	for (var j=0; j < styleSheet.cssRules.length; j++){
     		alert(styleSheet.cssRules[j].style.cssText)
+    	}
     */
+    }
     //alert("SHEET="+sheet.cssRules.length)
     //document.head.appendChild(style);
     """
     /*
      */
     if (!(editor.getClass().getName().equals(")org.txm.edition.rcp.editors.SynopticEditionEditor"))) {
     	println "Editor is not an edition: "+editor+". Use the F12 key binding to run the macro."
     	return
+    }
     monitor.syncExec(new Runnable() {
     	public void run() {
     		panel = editor.editionPanels["default"]
     		println "Execute result: "+panel.execute(script)
     }});

     import java.io.File;
     import java.io.IOException;
     import org.osgi.framework.Version;
     import org.txm.PostTXMHOMEInstallationStep;
     import org.txm.Toolbox;
     import org.txm.objects.Workspace;
     import org.txm.utils.BundleUtils;
     import org.txm.utils.io.FileCopy;
     import org.txm.utils.logger.Log;
     /**
      * Copy all Groovy scripts in TXMHome directory
-...
     	public boolean do_install(Workspace workspace) {
     		File txmhomedir = new File(Toolbox.getTxmHomePath());
     		String version = GroovyPreferences.getInstance().getString(GroovyPreferences.VERSION);
     		boolean doInstall = false;
     		Version installedVersion = BundleUtils.getBundleVersion("org.txm.groovy.core");
     		if (version != null && version.length() > 0) {
     			Version v = new Version(version);
     			doInstall = v.compareTo(installedVersion) > 0;
     			Log.fine("Groovy installed version: "+installedVersion+" preferenced version: "+v+" -> "+doInstall);
     		} else {
     			doInstall = true;
     			GroovyPreferences.getInstance().put(GroovyPreferences.VERSION, installedVersion.toString());
+    		}
     		if (!doInstall) return true; // nothing to do
     		for (String folder : createfolders) {
     			new File(txmhomedir, folder).mkdirs();
+    		}
     		File scriptsDirectory = new File(txmhomedir, "scripts/groovy");
     		File userDirectory = new File(scriptsDirectory, "user");
     		File systemDirectory = new File(scriptsDirectory, "system");
     		Log.fine("Installing Groovy files to "+userDirectory);
     //		HashMap<String, String> publishedImports = new HashMap<String, String>();
     //		String IMPORTERPACKAGE="org/txm/scriptsimporter/";
     //		publishedImports.put(IMPORTERPACKAGE+"alceste","alcesteLoader.groovy");
-...
     //		publishedImports.put(IMPORTERPACKAGE+"doc","docLoader.groovy");
     //		publishedImports.put(IMPORTERPACKAGE+"cqp","cqpLoader.groovy");
     //
     //
     //		for (String p : publishedImports.keySet()) {
     //			BundleUtils.copyFiles(bundle_id, "src/", "groovy/"+p, publishedImports.get(p), importDirectory);
     //		}
-...
     		try {
     			FileCopy.copyFiles(userDirectory, systemDirectory);
     			Log.fine("Copying user Groovy files to "+systemDirectory);
     		} catch (IOException e) {
     			// TODO Auto-generated catch block
     			e.printStackTrace();
+    		}
     		return scriptsDirectory.exists();
+    	}

     	public static final String PREFERENCES_NODE = GroovyPreferences.class.getName();//FrameworkUtil.getBundle(RPreferences.class).getSymbolicName();
     	public static final String VERSION = "version";
     	/**
     	 * Gets the instance.
     	 * @return the instance
     	 */
     	public static TXMPreferences getInstance()	{
     		if (!TXMPreferences.instances.containsKey(GroovyPreferences.class)) {
     			new GroovyPreferences();
+    		}
     		return TXMPreferences.instances.get(GroovyPreferences.class);
+    	}
     	@Override
     	public void initializeDefaultPreferences() {
     		super.initializeDefaultPreferences();
     		// TODO Auto-generated method stub
+    	}
+    }

     package org.txm.macro.office
     import org.kohsuke.args4j.*
     import groovy.transform.Field
     import java.nio.charset.Charset
     import org.txm.rcpapplication.swt.widget.parameters.*
     import org.txm.utils.*
     import javax.xml.stream.*
     import java.net.URL
     import org.apache.poi.ss.usermodel.*
     import org.apache.poi.hssf.usermodel.*
     import org.apache.poi.xssf.usermodel.*
     import org.apache.poi.ss.util.*
     @Field @Option(name="inputDirectory", usage="répertoire des fichiers Excel à traiter", widget="Folder", required=true, def="")
     		def inputDirectory
     @Field @Option(name="outputFile", usage="output file", widget="File", required=true, def="")
     		def outputFile
     @Field @Option(name="sheetName", usage="sheet name (if no name is given the first sheet will be used)", widget="String", required=false, def="")
     		def sheetName
     @Field @Option(name="columnList", usage="column list to extract, separated with comma", widget="String", required=false, def="")
     		def columnList
     if (!ParametersDialog.open(this)) return
     	if (!inputDirectory.exists()) {
     		println "** $scriptName: no '"+inputDirectory.name+"' directory found. Aborting."
     		return false
+    	}
     if (!inputDirectory.canRead()) {
     	println "** $scriptName: '"+inputDirectory.name+"' directory not readable. Aborting."
     	return false
+    }
     def scriptName = this.class.getSimpleName()
     columnList = columnList.split("\t")
     println "columnList = "+columnList
     // create output file
     out = new FileOutputStream(outputFile)
     HSSFWorkbook wb = new HSSFWorkbook()
     finalSheet = wb.createSheet()
     // create header line
     int nFinalRows = 1
     r = finalSheet.createRow(0)
     columnList.eachWithIndex { columnName, i ->
     	c = r.createCell(i)
     	c.setCellValue(columnName)
+    }
     def f = []
     inputDirectory.eachFileMatch(~/.*xlsx/) { f << it }
     if (f.size() == 0) {
     	println "** $scriptName: no .xlsx file found. Aborting."
     	return false
+    }
     debug = false;
     ConsoleProgressBar cpb = new ConsoleProgressBar(f.size())
     try {
     	f.sort { it.name }.each { inputFile ->
     		if (debug) println "Processing "+inputFile+"."
     		cpb.tick()
     		rownum = 0
     		// open input stylesheet
     		Workbook wb2 = WorkbookFactory.create(inputFile)
     		Sheet ws = null;
     		if (sheetName.length() == 0) {
     			ws = wb2.getSheetAt(0)
     		} else {
     			ws = wb2.getSheet(sheetName)
     			if (ws == null) {
     				println "** Excel2XML: no '"+sheetName+" found. Aborting."
     				return false
+    			}
+    		}
     		if (ws == null) {
     			println "** $scriptName: no sheet found. Aborting."
     			return false
+    		}
     		nRows = ws.getPhysicalNumberOfRows()
     		if (debug) println nRows+" rows."
     		Row firstRow = ws.getRow(0) // get header line
     		int nCells = firstRow.getPhysicalNumberOfCells()
     		def cellIndexes = []
     		for (int iCell = 0 ; iCell < nCells ; iCell++) { // get indexes of columns to copy
     			String value = firstRow.getCell(iCell).getStringCellValue()
     			if (columnList.contains(value)) {
     				cellIndexes << iCell
+    			}
+    		}
     		for (int iRow = 1 ; iRow < nRows ; iRow++) { // copy rows from next lines
     			Row row = ws.getRow(iRow)
     			r = finalSheet.createRow(nFinalRows)
     			int nCellCreated = 0
     			for (int iCell : cellIndexes) {
     				String value = row.getCell(iCell).getStringCellValue()
     				Cell c = r.createCell(nCellCreated)
     				c.setCellValue(value)
     				nCellCreated++
+    			}
     			nFinalRows++
+    		}
+    	}
     } catch(Exception e) {
     	return false;
+    }
     cpb.done();
     /* write sheet */
     wb.write(out)
     out.close()
     println nFinalRows+" rows written."
     return true

     import java.io.File;
     import java.io.FileFilter;
     import org.txm.utils.io.IOUtils;
     // TODO: Auto-generated Javadoc
     /**
      * The Class FileTreeContentProvider.
-...
     		Object[] kids = ((File) element).listFiles(new FileFilter() {
     			@Override
     			public boolean accept(File file) {
     				if (file.isHidden()) return false;
     				if (file.isDirectory()) return true;
     				if (file.isHidden()) return false;
     				if (macroExplorer.isShowAll()) return true;
     				if (!file.getName().endsWith("Macro.groovy")) return false; //$NON-NLS-1$
     				return file.getName().endsWith("Macro.groovy"); //$NON-NLS-1$
     				String line = IOUtils.firstLine(file);
     				if (line != null) {
     					line = line.trim();
     					return !(line.contains("@STATUS=BETA") || line.contains("@STATUS=ALPHA"));
+    				}
     				return true;
+    			}
     		});

tmp/org.txm.utils/src/org/txm/utils/io/IOUtils.java (revision 2024)
26	26	import org.txm.utils.i18n.DetectBOM;
27	27
28	28	public class IOUtils {
29
	29
30	30	public static final String UTF8 = "UTF-8"; //$NON-NLS-1$
31	31
32	32	public static ArrayList<String> findWithGroup(File file, String pattern) throws IOException {
33	33	return findWithGroup(file, UTF8, pattern, false);
34	34	}
35
	35
36	36	public static ArrayList<String> findWithGroup(File file, String pattern, boolean normalizeSeparators) throws IOException {
37	37	return findWithGroup(file, UTF8, pattern, normalizeSeparators);
38	38	}
39
	39
40	40	public static ArrayList<String> findWithGroup(File file, String encoding, String pattern) throws IOException {
41	41	return findWithGroup(file, encoding, pattern, false);
42	42	}
43
	43
44	44	/**
45	45	* select only files not hidden
46	46	*/
...	...
50	50	return !file.isHidden() && !file.getName().startsWith(".") && !file.getName().endsWith("~");
51	51	}
52	52	};
53
	53
54	54	/**
55	55	*
56	56	* @return a list containing the files not hidden
...	...
58	58	public List<File> listFiles(File dir) {
59	59	File[] files = dir.listFiles(HIDDENFILE_FILTER);
60	60	if (files == null) return new ArrayList<File>();
61
	61
62	62	return Arrays.asList(files);
63	63	}
64
	64
65	65	public static ArrayList<String> findWithGroup(File file, String encoding, String pattern, boolean normalizeSeparators) throws IOException {
66	66	ArrayList<String> matches = new ArrayList<String>();
67	67	String text = IOUtils.getText(file, encoding);
...	...
71	71	text = text.replaceAll("\\n", " "); //$NON-NLS-1$
72	72	text = text.replaceAll("[ ]+", " "); //$NON-NLS-1$
73	73	}
74
	74
75	75	Pattern test = Pattern.compile(pattern);
76	76	Matcher m = test.matcher(text);
77	77	while (m.find()) {
...	...
79	79	}
80	80	return matches;
81	81	}
82
	82
83	83	public static ArrayList<String> find(File file, String pattern) throws IOException {
84	84	return find(file, UTF8, pattern, false);
85	85	}
86
	86
87	87	public static ArrayList<String> find(File file, String pattern, boolean normalizeSeparators) throws IOException {
88	88	return findWithGroup(file, UTF8, pattern, normalizeSeparators);
89	89	}
90
	90
91	91	public static ArrayList<String> find(File file, String encoding, String pattern) throws IOException {
92	92	return find(file, encoding, pattern, false);
93	93	}
94
	94
95	95	public static ArrayList<String> find(File file, String encoding, String pattern, boolean normalizeSeparators) throws IOException {
96	96	ArrayList<String> matches = new ArrayList<String>();
97	97	String text = IOUtils.getText(file, encoding);
...	...
102	102	text = text.replaceAll("\\n", " "); //$NON-NLS-1$ //$NON-NLS-2$
103	103	text = text.replaceAll("[ ]+", " "); //$NON-NLS-1$ //$NON-NLS-2$
104	104	}
105
	105
106	106	Pattern test = Pattern.compile(pattern);
107	107	Matcher m = test.matcher(text);
108	108	while (m.find()) {
...	...
110	110	}
111	111	return matches;
112	112	}
113
	113
114	114	public static BufferedReader getReader(File file) throws UnsupportedEncodingException, FileNotFoundException {
115	115	return getReader(file, UTF8);
116	116	}
...	...
130	130	public static BufferedReader getReader(String file) throws UnsupportedEncodingException, FileNotFoundException {
131	131	return getReader(new File(file), UTF8);
132	132	}
133
	133
134	134	public static BufferedReader getReader(URL url) throws IOException {
135	135	return getReader(url, UTF8);
136	136	}
...	...
145	145	writer.print(text);
146	146	writer.close();
147	147	}
148
	148
149	149	public static String getText(URL url, String encoding) throws IOException {
150	150	BufferedReader reader = getReader(url, encoding);
151	151	StringBuilder builder = new StringBuilder();
...	...
161	161	}
162	162	return builder.toString();
163	163	}
164
	164
165	165	public static String getText(File xmlWFile, String string) throws IOException {
166	166	BufferedReader reader = getReader(xmlWFile);
167	167	StringBuilder builder = new StringBuilder();
...	...
235	235	public static OutputStream getOutputStream(File file) throws FileNotFoundException {
236	236	return new BufferedOutputStream(new FileOutputStream(file, false));
237	237	}
238
	238
239	239	public static OutputStream getOutputStream(File file, boolean append) throws FileNotFoundException {
240	240	return new BufferedOutputStream(new FileOutputStream(file, append));
241	241	}
...	...
245	245	text = text.replace(oldString, newString);
246	246	IOUtils.write(file, text);
247	247	}
248
	248
249	249	public static void replaceAll(File file, Pattern regex, String newString) throws IOException {
250	250	String text = getText(file, UTF8);
251	251	text = regex.matcher(text).replaceAll(newString);
252	252	IOUtils.write(file, text);
253	253	}
	254
	255	public static String firstLine(File file) {
	256	try {
	257	BufferedReader reader = getReader(file);
	258	String line = reader.readLine();
	259	reader.close();
	260	return line;
	261	} catch(Exception e) {
	262	return null;
	263	}
	264	}
254	265	}

Laboratoire ICAR » Plateforme TXM

Révision 2024