Menu

document Function - RowToColumn

ema manu

RowToColumn

This functions transpose a row in a column.

example:

select *
from [dbo].[RowToColumn]('path','file','|',1,-1)

paramenters:

@path:
it's the path of file

@file:
the file to open

@delimitator:
it's the delimitator of the text columns;
in case of excel this will be ignored.

@xls:
-if <0 that means it's a text file, else it's the sheet of the excel


Want the latest updates on software, tech news, and AI?
Get latest updates about software, tech news, and AI from SourceForge directly in your inbox once a month.