Queries about Aspose cells smart markers

Aspose.Cells Product Family
21

@pgcentric,

Thanks for the template Excel file and details.

After initial testing, I am able to reproduce the issue as you mentioned by using your template Excel file and sample code snippet. I found an issue with rendering array of objects in JSON data. I noticed for index 0, it prints only a single value, whereas for the rest of the indices, it prints all values.

We require thorough evaluation of the issue. We have opened the following new ticket(s) in our internal issue tracking system and will deliver their fixes according to the terms mentioned in Free Support Policies.

Issue ID(s): CELLSJAVA-46275

You can obtain Paid Support Services if you need support on a priority basis, along with the direct access to our Paid Support management team.

22

@pgcentric
We are pleased to inform you that your issue CELLSJAVA-46275 has been resolved. The fix will be included in our upcoming release (Aspose.Cells for Java v25.3) that we plan to release in the first half of March 2025. You will be notified when the next version is released.

23

Hi ,

  1. We are testing Smart Markers to populate data in the header and footer, but the values are not getting populated. Could you please check the attached file?
  2. If we have a key that is an array, how can we retrieve the value for a specific index instead of populating all values?
  • For example, given "key": [10, 20, 30], how can we extract only the value at index 0 (i.e., 10)?

Looking forward to your guidance.

header-footer.zip (8.1 KB)

 void excel(){
    try {
      String data = "smart_marker.json";
      String fileName = "src/test/resources/input/excel/templates/QA_Header_Footer_Template.xlsx";

      final WorkbookDesigner designer = new WorkbookDesigner();
      designer.setWorkbook(new Workbook(fileName));
      String[] smartMarkers = designer.getSmartMarkers();
      List<String> markers = Arrays.asList(smartMarkers);
      log.debug("Got smart markers {}", markers);
      String jsonFile = testFileUtils.readJsonFile("input/excel/data", data);
      designer.setJsonDataSource("node", jsonFile);
      designer.process();
      designer
              .getWorkbook()
              .save("src/test/resources/input/excel/smart_header_out.xlsx", SaveFormat.XLSX);
    } catch (Exception e) {
      throw new RuntimeException(e);
    }
  }
24

@pgcentric,

  1. We are afraid, you cannot set Header and Footer using Smart Marker tags/placeholders. Please note, headers/footers are added with the help of script commands, so you will have to set them separately in you code. Please see the following documentation article that illustrates how to set Headers and Footers using Aspose.Cells API.
  2. & 3. We recently supported accessing array element by index for Smart Markers. See the thread for your complete reference. The enhancements will be included in the upcoming release (Aspose.Cells for .NET v25.3).
25

@pgcentric

I’m afraid, I can’t support your needs.

  1. The “&” symbol serves as the escape character for headers and footers.
  2. It is challenging for us to identify the smart marker strings within the header/footer content.
26

The issues you have found earlier (filed as CELLSJAVA-46275) have been fixed in Aspose.Cells for Java 25.3.

27

@pgcentric
Please try the [] to export specific data with smart marker as the following :
&=RootData.Directors[1].reportees.FirstName : Export the second Director
&=RootData.Directors[2:-1].reportees.id : Export the Directors from the third to end

28

@pgcentric,

This is to inform you that your issue (Ticket ID: “CELLSJAVA-46248”) has been resolved. The fix will be included in our upcoming release (Aspose.Cells v25.4) that we plan to release in the first half of April 2025. You will be notified when the next version is released.

29

Thank you , We have one more query regarding image markers. We attempted to use node.logo(Picture) with a base64 value from JSON, and it worked. However, we couldn’t find an exact example of this syntax in the documentation. Most examples we came across use node.logo(Picture:FitToSize). Could you confirm if our approach is valid or provide guidance on best practices?

30

@pgcentric
Regarding how to use image smarters, please refer to the following document.

If you still have questions, would you like to provide us with sample files, test data, and runnable test code? We will check it soon.

31

Thanks but my question was only related to “node.logo(Picture)” if this is valid syntax ? was able to generate document with this syntax. I have checked this documentation. It does not explicitly state that you can use just "Picture". It only lists "Picture:FitToCell", "Picture:ScaleN", and "Picture:Width:Nin&Height:Nin" as valid parameters for handling images.

32

@pgcentric
node.logo(Picture) is supported too.

33

Thank you , We observed that Picture:Top:2in and Picture:Top:200 are not positioning images as expected in Aspose.Cells Smart Markers. Despite trying both inches and points, the alignment seems incorrect.

Attached are the template, JSON, and output for reference. Could you please assist?
Version:25.2

 @Test
  void generatedDocumentWithExcel() {
    try {
      String data = "smartMarkers.json";
      String fileName = "src/test/resources/input/excel/templates/smart_markers.xlsx";
      final WorkbookDesigner designer = new WorkbookDesigner();
      designer.setWorkbook(new Workbook(fileName));
      String[] smartMarkers = designer.getSmartMarkers();
//      List<String> smartMarkersList = Arrays.asList(smartMarkers);
//      log.debug("Got smart markers {}", smartMarkersList);
      String jsonFile = testFileUtils.readJsonFile("input/excel/data", data);
      designer.setJsonDataSource("node", jsonFile);
      designer.process();
      designer
              .getWorkbook()
              .save("src/test/resources/input/excel/test-smart-marker-output.xlsx", SaveFormat.XLSX);
    } catch (Exception e) {
      throw new RuntimeException(e);
    }
  }

smart_markers.zip (24.9 KB)

34

@pgcentric,

Thanks for the JSON data file and template Excel file.

I tested your scenario using the provided code snippet, JSON data, and sample Excel file, and noticed some differences in positioning. Could you please also share an Excel file that includes your expected results for the images alignment and positioning? This will help us accurately evaluate the issue and resolve it promptly.

35

@pgcentric
Picture:Top is used to set offset to the top border, but the upper left corner of the image is limited to the current cell now. As 2in is greater then the height of the row, do you want to move the picture to other cell?

36

Thank you for clarifying that Top and Left are relative to cell height and width. I didn’t realize that before, but now it’s working as expected!

37

@pgcentric
Thank you for your feedback. You are welcome. I’m glad you followed the prompts to solve the issue. If you have any questions, please feel free to contact us at any time.