Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

save data in excel

hello, in fabric dataflow, after some transformations, I have got the data. Now I would like to save this data as excel. How do I do this?  thanks
Dataflows
  • Anonymous's avatar
    Anonymous
    2 years ago

    Hi Anonymous 
    I am adding the code snippet here:

     

     

    import pandas as pd
df = spark.sql("SELECT * FROM lakehouse_1.customers_1000")
df1= df.toPandas()
df1.to_excel('abfss://[email protected]/lakehouse_1.Lakehouse/Files/sample.xlsx')

     


    Just replace with the abfss path of your lakehouse files folder.



     



    Hope this helps.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

can you please send the pyspark equivalent to your notebook code?

thank you

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Anonymous 
I am adding the code snippet here:

 

 

import pandas as pd
df = spark.sql("SELECT * FROM lakehouse_1.customers_1000")
df1= df.toPandas()
df1.to_excel('abfss://[email protected]/lakehouse_1.Lakehouse/Files/sample.xlsx')

 


Just replace with the abfss path of your lakehouse files folder.



 



Hope this helps.

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    now that I can save the dataframe as .xlsx, how do I open the excel file which is now in the Files folder?

    my goal is to eventually email this excel file to someone

    thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi Anonymous 
      As specified above you can use Onelake explorer in your local machine to download the file. Then you can send it via email.

      You can also download this file into your local desktop using Onelake explorer.
      Access Fabric data locally with OneLake file explorer - Microsoft Fabric | Microsoft Learn

       

      Download the latest version of Onelake explorer and sync the Lakehouse.

       

       

      Hope this helps. Please let me know if you have any further questions.

      • Anonymous's avatar
        Anonymous
        Not applicable
        2 years ago

        Hi Anonymous 

        Glad that your query got resolved. Please continue using Fabric Community for any help regarding your queries.