How to work on unstructured data in excel using uipath if excel contain macros in background?

How to work on unstructured data in excel using UiPath? This excel contains formulas and macros in background? I Used Generate Table to get unstructured data from excel but, I am not able to get that data from excel? what might be the solution for this kind of situations?

Can some one respond with sample example.

Even though your excel have macros that will not affect your bot run… As per previous post any sample input and expected output??

Its office data confidential. Can you explain or if possible attach me xaml file…I can understand.
And, in that excel, values of saturday, sunday, public holiday should be replaced previous days values…Like for sat, sun gets value of friday. for holiday gets previous day value. How can we done.