EXCEL : .SLK file not showing data in table format

Question

When I am exporting data from my application as HTML in Excel and saving in .SLK file ,It displays data in HTML tag format(which is not useful). I need data in table format.

But when I change the file extension .SLK to .SLYK and open in EXCEL then it displays the data properly in Table format.

I need data in table format with file extension as .SLK.

Can someone please help me?

jkpieterse · Answer

SYLK is a very specific file format which is totally different from HTML. Try using .html as file extension.

satyaprakashsp · Answer

JKPieterse&nbsp; Thanks for the info.&nbsp;But I need a file with .SLK extension, which should display data in proper table format.Below are the screenshots which shows data in .SLK and .SYLK files. Data in .SYLK file is readable(in table format), but in .SLK data are having HTML tags.First Screenshot shows .SLK file and Second screenshot shows .SYLK file.&nbsp;&nbsp; &nbsp;So I need data properly displayed(like .SYLK file) in .SLK file.&nbsp;

jkpieterse · Answer

The first screenshot clearly denotes a file which is in html format, NOT in SYLK format. How are you creating these files?

satyaprakashsp · Answer

JKPieterse&nbsp;Thanks for the quick reply.&nbsp;From our application we are exporting data in HTML format and saving as .SLK file.Now if I open this .SLK file then it shows data in HTML tags, but when I change the file extension to .SYLK of the same file then it displays data in Table format. So I think when opening .SYLK file some implicitly conversion (HTML tags to Table format) is happening and it display data properly in table format.But it's not happening when I open .SLK file and it still shows HTML tags format only.Is there any settings or a way , which can get me the data in table format for .SLK file?&nbsp;

satyaprakashsp · Answer

JKPieterse&nbsp;&nbsp;&nbsp;Is it possible to ever generate a .SLK file with tabular format? (when I exported the data in HTML format and saved the file with .SLK extension)&nbsp;Answer for above question would help me.&nbsp;&nbsp;

Forum Discussion

EXCEL : .SLK file not showing data in table format

9 Replies

Resources