----------------------
I'm sorry, but based on the information provided in the knowledge sources, there's no explicit mention of the ability to read formulas from Excel files using the
PandasExcelReader class in LlamaIndex. The
PandasExcelReader class uses the
read_excel function from the pandas library to parse Excel files, and this function typically reads the values of cells, not the formulas.
However, you might be able to achieve this by using the
read_excel function with specific parameters. You would need to refer to the pandas documentation for more details on this.
Here is the basic usage of the
PandasExcelReader class:
class PandasExcelReader(BaseReader):
def __init__(
self,
*args: Any,
concat_rows: bool = True,
sheet_name=None,
pandas_config: dict = {},
**kwargs: Any
) -> None:
super().__init__(*args, **kwargs)
self._concat_rows = concat_rows
self._sheet_name = sheet_name
self._pandas_config = pandas_configYou can find more details about the
PandasExcelReader class in the
LlamaIndex documentation ().
For more advanced usage or specific needs, you might need to extend the
PandasExcelReader class or create a custom reader.
----------------------
Note: you can ask me a follow up question by @ mentioning me again :speech_balloon:
----------------------
