We're sorry Aspose doesn't work properply without JavaScript enabled.

Free Support Forum - aspose.com

Extract a table of content from Excel to Word using Aspose with Java

Aspose.Cells Product Family
#1

Hi

Now my requirement is I have to take a table of content from Excel and paste it in Word document using Aspose with Java.

Is there any possibility that I can do some kind of copy and paste from Excel to Word.

I want to select a range of cells only. like C1...D13(which has two columns and 13 rows.

It is my doubt can anyone help me?

Thanks in Advance

Madhu

#2

Hi,

Yes, I think you may use Cells.exportArray() method to fill a two dimensional array and later paste it into the word document using Aspose.Word API.

Thank you.

#3

Hi Amjad,

I am very new to this Aspose usage.

Can you please tell me how can I implement Cells.exportArray() Using Aspose with Java.

I want to maintain te same format like backgroung colour of cell to be same in the word document also.

Can you help me?

Thanks in Advance

Madhu

#4

Hi,

Well Cells.exportArray() will only export data not formattings, check the doc how you can use the method: http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/exporting-data-from-worksheets.html If you want to extract data with formattings, there is no direct way to do the task. I think you may try to iterate the source cells one by one in a loop, check each cell to get its data and formattings usng the methods e.g., Cell.getValue and Cell.getStyle(), now paste the values and re-format the data accordingly using Aspose.Words API.

Thank you.

#5

Hi Amjad,

Thanks for your valuable suggestion.

I am checking it out.

Once it is done I will let you know.

Thnaks

madhu

#6

Hi Amjad

I worked with the code given by you.

The object has information. But my doubt is how can I paste or write that object to Word Document.

Please help me as I am very new to use this Aspose

Here is the code line of me.

Object dataTable [][] = worksheet.getCells().exportArray(74,7,54,6);

Thanks

Madhu

#7

Hi Madhu,

Sorry, I am not familiar with Aspose.Words API. I think you can check Aspose.Words documentation:

or post a query @ Aspose.Words forum:

and I am sure they will help you soon.

Thank you.

#8

Hi Amjad,

Thank you fo ryour replies.

I posted my message in Aspose.Words forum.

Bye

Madhu

#9

Hi,

I have a doubt in Aspose Cells like

what is the Exact replacement for TextOrientationType(in C#) for java

Thanks

Madhu

#10

Hi Madhu,

Do you use TextBox object, well, in the java version, you may use MsoTextOrientation interface in parallel:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/com/aspose/cells/msotextorientation.html

To set the text orientation in a textbox, kindly use TextBox.setOrientation() method:

http://www.aspose.com/documentation/file-format-components/aspose.cells-for-.net-and-java/com/aspose/cells/textbox.html

Thank you.

#11

Hi Amjad,

Thanks for your information.

How can I convert picture type to shape type in Java.

Exactly what happened is that I have C# code where to there is direct convertion has done like this.

private com.aspose.words.Shape ConvertPictureToShape(com.aspose.cells.Picture excelPicture, Document doc)
{
//Create new Shape
com.aspose.words.Shape wordsShape=null;
try
{
wordsShape = new com.aspose.words.Shape(doc, com.aspose.words.ShapeType.IMAGE);
//Set image
wordsShape.getImageData().setImage(excelPicture.toString());
//Import Picture properties inhereted from Shape
ImportShapeProperties(wordsShape, (Shape)excelPicture);
}
catch(Exception e)
{
e.printStackTrace();
}
return wordsShape;
}

Actually the bolded thing is giving me error.

It is saying that you can not convert picture type to Shape directly. I have ImportShapeProperties method.

The same kind of error is coming for TextBox to Shape

Can you help me?

Thanks

madhu

#12

Hi Madhu,

Which version of Aspose.Cells for Java are you using? Would you please try our released version 1.9.5.x, or just use the latest fix I posted in your another thread: http://www.aspose.com/community/forums/137669/how-to-copy-data-from-excel-to-word/showthread.aspx#137669.