Login or Register to Ask a Question and Join Our Community


Programming

grouping and ungrouping of excel cells using java

Login to Discuss or Reply to this Discussion in Our Community

 
Thread Tools Search this Thread
Top Forums Programming grouping and ungrouping of excel cells using java
# 1  
Old 03-16-2010
grouping and ungrouping of excel cells using java
Dear Folks,
Is there anyone know how to do the group and ungroup cells feature of MS Excel through java.

Please help.

Please find the attachment.I want the code to do something like this.
New Microsoft Office Excel Worksheet.xls (10.6 KB) 
Login or Register to Ask a Question

Previous Thread | Next Thread

10 More Discussions You Might Find Interesting

1. Programming

Perl script to merge cells in column1 which has same strings, for all sheets in a excel workbook

Perl script to merge cells ---------- Post updated at 12:59 AM ---------- Previous update was at 12:54 AM ---------- I am using below code to read files from a dir and print to excel. open(my $in, '<', $file) or die "Could not open file: $!"; my $rowCount = 0; my $colCount = 0;... (11 Replies)
Discussion started by: Jack_Bruce
11 Replies

2. Shell Programming and Scripting

Perl script to Merge contents of 2 different excel files in a single excel file

All, I have an excel sheet Excel1.xls that has some entries. I have one more excel sheet Excel2.xls that has entries only in those cells which are blank in Excel1.xls These may be in different workbooks. They are totally independent made by 2 different users. I have placed them in a... (1 Reply)
Discussion started by: Anamika08
1 Replies

3. UNIX for Dummies Questions & Answers

Filling empty cells

How do you fill empty cells that do not have any data in them with "X" in a tab delimited text file? Thanks! (4 Replies)
Discussion started by: evelibertine
4 Replies

4. Programming

Excel reading on Linux using Java

Hi, I have a requirement where users will send excel(.xls) file to Linux Platform using ftp/sftp. After that the excel file needs to be read using java on linux and converted into csv. I am using jxl to parse the excel, but few character like £ are not getting parsed properly. If i open the... (0 Replies)
Discussion started by: joy_bt
0 Replies

5. UNIX Desktop Questions & Answers

Using grep to remove cells instead of lines

I would like to use grep to remove certain strings from a text file but I can't use the grep -v option because it removes the whole line that includes the string whereas I just want to remove the string. How do I go about doing that? My input file: Magmas CEU rs12542019 CPNE1 RBM12 CEU... (1 Reply)
Discussion started by: evelibertine
1 Replies

6. Programming

How to create java based dictionary for mobile using data in microsoft excel?

i am having a ms excel file which contains 2 columns, I first column i added words, and in second column meaning to the word in the first column. I want to create a dictionary for mobile like nokia or any java based application running mobile. How it can be created as i, dont know the java... (1 Reply)
Discussion started by: Anna Hussie
1 Replies

7. Shell Programming and Scripting

Merge two cells in excel via UNIX?

Hi UNIX Gods! Is it possible to merge two cells in .csv file using unix commands? Imagine that this is my present csv file opened via excel: Gate Reports| | fatal alerts | 200 | is is possible to make it look like this using unix? Gate Reports | fatal... (1 Reply)
Discussion started by: 4dirk1
1 Replies

8. Shell Programming and Scripting

Comparison of Cells in EXCEL using awk

Hi I have 2 csv files which looks like the following and i have to compare the 2 CSVs and create a third file such that if the value of the 1st cell in A.CSV and the value of the first cell in the B.CSV are same, it should print "SAME" in the third file or else print NOT SAME. Likewise i need... (19 Replies)
Discussion started by: meva
19 Replies

9. Shell Programming and Scripting

UNIX -> send data as excel in seperate cells

Hi I have a data file in UNIX as follows. I need to send this file in Mail as excel format. but the problem i face is i get the data all in single cells per row. what can i do to get the data in seperate cells. File -> attachment.xls data data data data data1 data1 ... (1 Reply)
Discussion started by: vj8436
1 Replies

10. Shell Programming and Scripting

PERL: Split Excel Workbook to Indiv Excel files

Hi, I am trying to find a way to read an excel work book with multiple worksheets. And write each worksheet into a new excel file using perl. My environment is Unix. For example: I have an excel workbook TEST.xls and it has Sheet1, Sheet2, Sheet3 worksheets. I would like to create... (2 Replies)
Discussion started by: sandeep78
2 Replies
Login or Register to Ask a Question

LEARN ABOUT MOJAVE

schemagen

schemagen(1)						      General Commands Manual						      schemagen(1)

NAME

       schemagen - Java(TM) Architecture for XML Binding Schema Generator Specification Version: 2.0
       Reference Implementation (RI) Version: 2.0 ea3

   Launching schemagen
       The schema generator can be launched using the appropriate schemagen shell script in the bin directory for your platform.

       The current schema generator can process either Java source files or class files.

       We also provide an Ant task to run the schema generator - see the instructions for using schemagen with Ant.

	  For Solaris/Linux

		% path/to/jaxb/bin/schemagen.sh Foo.java Bar.java ...
		Note: Writing schema1.xsd

	  For WindowsNT/2000/XP

		> path	ojaxbinschemagen.bat Foo.java Bar.java ...
		Note: Writing schema1.xsd

       If your java sources/classes reference other classes, they must be accessable on your system CLASSPATH environment variable, or they need
       to be given to the tool by using the -classpath/-cp options. Otherwise you will see errors when generating your schema.

	  Command Line Options

	     Usage: schemagen [-options ...] <java files>

	     Options:
		 -d <path>	   :  Specify where to place processor and javac generated class files
		 -cp <path>	   :  Specify where to find user specified files
		 -classpath <path> :  Specify where to find user specified files
		 -help		   :  Display this usage message

   Generated Resource Files
       The current schema generator simply creates a schema file for each namespace referenced in your Java classes. There is no way to control
       the name of the generated schema files at this time. For that purpose, use the schema generator ant task.

See Also
	  o JAXB 2.0:

	     * Release Notes @
	       http://java.sun.com/webservices/docs/2.0/jaxb/ReleaseNotes.html

	     * XJC @
	       http://java.sun.com/webservices/docs/2.0/jaxb/xjc.html

	     * XJCTask @
	       http://java.sun.com/webservices/docs/2.0/jaxb/xjcTask.html

	     * SchemaGen @
	       http://java.sun.com/webservices/docs/2.0/jaxb/schemagen.html

	     * schemagenTask @
	       http://java.sun.com/webservices/docs/2.0/jaxb/schemagenTask.html

	     * Sample Apps @
	       http://java.sun.com/webservices/docs/2.0/jaxb/samples.html

	     * Changelog @
	       http://java.sun.com/webservices/docs/2.0/jaxb/changelog2.html

	  o JAXB 1.0.x:

	     * Release Notes @
	       http://java.sun.com/webservices/docs/2.0/jaxb/jaxb-1_0.html

	     * Changelog @
	       http://java.sun.com/webservices/docs/2.0/jaxb/changelog.html

	  o JAXB RI Extensions:

	     * Runtime Properties @
	       http://java.sun.com/webservices/docs/2.0/jaxb/vendorProperties.html

	     * XJC Customizations @
	       http://java.sun.com/webservices/docs/2.0/jaxb/vendorCustomizations.html

	     * Develop Plugins @
	       http://java.sun.com/webservices/docs/2.0/jaxb/developPlugins.html

	  o JAXB RI Schema Languages:

	     * W3C XML Schema @
	       http://java.sun.com/webservices/docs/2.0/jaxb/vendorSchemaLangs.html#xschema

	     * RELAX NG @
	       http://java.sun.com/webservices/docs/2.0/jaxb/vendorSchemaLangs.html#relaxng

	     * DTD @
	       http://java.sun.com/webservices/docs/2.0/jaxb/vendorSchemaLangs.html#dtd

	  o JAXB Community:

	     * Java.net Homepage @
	       http://jaxb.dev.java.net

	     * Developer interest list @
	       https://jaxb.dev.java.net/servlets/ProjectMailingListList

	     * FAQ @
	       https://jaxb.dev.java.net/faq/index.html

								    07 Aug 2006 						      schemagen(1)