Project Franklin / Helix . Help with Excel Sheets !

[VeenaVikraman]

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 

[Nirmal_Jose · Accepted solution]

Hi @VeenaVikraman ,

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

[VeenaVikraman]

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.

[Nirmal_Jose]

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. 

[VeenaVikraman]

That makes more sense @Nirmal_Jose 

[Lakshmi99]

Hi @Nirmal_Jose @VeenaVikraman,

I need some help on the franklin forms. My requirement is to send an email along with form data to the user once form is submitted.

Can able to store the form data in excel.

I have gone through the helix docs but its very high level.

https://main--afb--adobe.hlx.live/docs/email-pa

Could you please provide me more details on this if you have any?

Thank you!

[Lakshmi99]

Hi @Nirmal_Jose @VeenaVikraman could you please help me on the below if you have any idea.

My req is to send an email along with the form data to the user after submitting the form. I have gone through the below doc but it doesn't have much info.

https://main--afb--adobe.hlx.live/docs/email-pa

Thank you!