Partiality formatted cells

Hi. One of our customers sent to us excel. There is partiality formatted (2 digit formatted in one format, two in another).

Is there is some way to get that formats?in.zip (6.3 KB)

P.S. Very uncomfortable to archive example “xlsx” files before sending. Will be very useful to allow attach that files

@makarovalv,

Thanks for the template file.

See the following sample code on how to superscript certain number(s) in a a given data for your rererence:
e.g
Sample code:

[C#]
Workbook excel = new Workbook();
Worksheet worksheet = excel.Worksheets[0];
Cells cells = worksheet.Cells;
cells[0,0].PutValue(“(a+b)2”);
cells[0, 0].Characters(5,1).Font.IsSuperscript =true;
excel.Save(“e:\test2\out1superscripts1.xls”);

[Java]
Workbook excel = new Workbook();
Worksheet worksheet = excel.getWorksheets().get(0);
Cells cells = worksheet.getCells();
cells.get(0,0).putValue(“(a+b)2”);
cells.get(0, 0).characters(5,1).getFont().setSuperscript(true);
excel.save(“e:\test2\out1superscripts1.xls”);

Also, see the documents for your reference on how to format cells, data and deal with fonts, etc.:
Format cells|Documentation [.NET]
Data Formatting|Documentation [Java]
Format cells|Documentation [.NET]
Cells Formats|Documentation [Java]
Font Settings|Documentation [.NET]
Dealing with Font Settings|Documentation [Java]

Hope, this helps a bit.

Thank you very much. It was very helpful for me

Best regards. Alexey

@makarovalv,

Good to know that the sample code and reference articles/documents are helpful to you. Feel free to write us back if you have further comments or questions, we will be happy to assist you soon.