Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Adobe Summit 2023 [19th to 23rd March, Las Vegas and Virtual] | Complete AEM Session & Lab list

Project Franklin / Helix . Help with Excel Sheets !

Avatar

Community Advisor

Hi Team

 

I am trying to work on a POC with Helix in which I am trying to generate a website using input from Excel sheets. Unfortunately, there is not much information available about this ambitious project from Adobe. I have found very little documentation on the implementation and no community help content either.

 

I have referred to https://www.hlx.live/home and https://www.hlx.live/developer/tutorial. This tutorial talks about using Google Docs. According to the documentation (https://www.hlx.live/docs/faq), Franklin supports editing content in Microsoft Word, Google Docs, Microsoft Excel, and Google Sheets, as well as any custom authoring environment and AEM's Universal Editor.

 

I want to do a POC on converting Excel to a website using Helix. Does anyone have any documentation, help docs, or blogs on this topic? Any help in any form would be appreciated at this point 😊

 

TIA

Veena ✌

 

cc: @kautuk_sahni 

4 Replies

Avatar

Employee Advisor

Hi @Veena_Vikram ,

 

Franklin supports excel/google sheets and documentation is at [1]

Please let me know if you run into any issues.

 

[1] - https://www.hlx.live/developer/spreadsheets

Avatar

Community Advisor

First of all, I would like to thank @Nirmal_Jose  for the documentation. However, it has not yet solved the problem. After reviewing the documentation at https://www.hlx.live/developer/spreadsheets, it appears that Franklin can translate spreadsheets (Microsoft Excel workbooks and Google Sheets) into JSON files that can be easily consumed by websites or web applications, in addition to translating Google Docs and Word documents into markdown and HTML markup.

 

While this means that a website can consume the JSON file, it does not necessarily mean that it can use it to create HTML for the website. I am a bit confused by Helix's documentation claim that it supports editing website content using Google Sheets.

Avatar

Employee Advisor

You are on point Veena.

 

Markup supported standards like GDocs and Word is used to create the semantic structures where as Excel is used as a data structure. Both can be used together to manage content easily for a website. 

 

Like you said, I don't think an excel into website UI is not supported without additional semantic support.