# Export string form correctly to excel?

**URL:** <https://community.wolfram.com/t/export-string-form-correctly-to-excel/14511>\
**Category:** Questions\
**Tags:** mathematica, external-interfaces, import-and-export\
**Created:** [July 23, 2019, 8:33pm UTC](https://community.wolfram.com/t/export-string-form-correctly-to-excel/14511 "2019-07-23T20:33:05Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![boeingx37](https://avatars.discourse-cdn.com/v4/letter/b/779978/32.png) [@boeingx37](https://community.wolfram.com/u/boeingx37)\
**Post date:** [July 23, 2019, 8:33pm UTC](https://community.wolfram.com/t/export-string-form-correctly-to-excel/14511/1 "2019-07-23T20:33:05Z")

</div>

Hello. I need to export all values of giant list to excel with string form.  
So I use this code

```
a = Table[
    Table[StringForm["strf``(``)=``", j, i - 1, b[[j]][[i]]], {i, 1, 
      10}], {j, 1, 1}] // Flatten // MatrixForm
Export["sf.xlsx", a]

```

And I get this output in mathematica  
strf1(0)=4.605170185988092` strf1(1)=6.638352067993813`  
strf1(2)=8.405946914885465` strf1(3)=10.045117514831617`  
strf1(4)=11.60462557947718` strf1(5)=13.108483652767925`  
strf1(6)=14.570618870336398` strf1(7)=15.99996345440759`  
strf1(8)=17.402652867352536` strf1(9)=18.783117393312526`  
But for excel I have this  
StringForm[“strf`(`)=`", 1, 0, 4.605170185988092] StringForm["strf`(`)=`”, 1, 1, 6.638352067993813]  
StringForm[“strf`(`)=`", 1, 2, 8.405946914885465] StringForm["strf`(`)=`”, 1, 3, 10.045117514831617]  
StringForm[“strf`(`)=`", 1, 4, 11.60462557947718] StringForm["strf`(`)=`”, 1, 5, 13.108483652767925]  
StringForm[“strf`(`)=`", 1, 6, 14.570618870336398] StringForm["strf`(`)=`”, 1, 7, 15.99996345440759]  
StringForm[“strf`(`)=`", 1, 8, 17.402652867352536] StringForm["strf`(`)=`”, 1, 9, 18.783117393312526]  
How to get the export file the same as the output from mathematica?  
Regards,  
Alex

---

<div class="post-metadata">

**Author:** ![soberania](https://yyz1.discourse-cdn.com/wolfram/user_avatar/community.wolfram.com/soberania/32/2174_2.png) [@soberania](https://community.wolfram.com/u/soberania)\
**Post date:** [July 24, 2019, 4:39am UTC](https://community.wolfram.com/t/export-string-form-correctly-to-excel/14511/2 "2019-07-24T04:39:23Z")

</div>

Hey Alex, you can do

```
a = Table[Table["strf" <> ToString@j <> "(" <> ToString[i - 1] <> ")=" <> ToString@b[[j]][[i]], {i, 1, 10}], {j, 1, 1}] // Flatten 

```

The result is:

 ![ex1.png](https://global.discourse-cdn.com/wolfram/original/3X/e/2/e200a828ba258b188e2a60bb852de30a1f9a81b5.png)

I hope that it works.