Qlik Community

QlikView Documents

QlikView documentation and resources.

Announcements
QlikWorld 2022, LIVE in Denver CO., May 16-19, 2022. REGISTER NOW TO RECEIVE EARLY BIRD PRICING

Import Excel File from SharePoint to QlikView without writing Job

cancel
Showing results for 
Search instead for 
Did you mean: 
lawrance
Creator II
Creator II

Import Excel File from SharePoint to QlikView without writing Job

How to Import Excel File from SharePoint to QlikView without writing Job

Import Excel file in SharePoint

Step 1: Create a New Folder in SharePoint (For E.g. QlikView)

Step 2: Upload Excel file in SharePoint QlikView folder

Now Our Dataset is uploaded successfully.

Add a Network Location in our Local Machine

Step 1: In SharePoint, Click Open with Explorer in Library menu

Step 2: It shows, Windows Security pop-up window

Step 3: Enter your credentials and click Ok

Step 4: It shows, Internet Explorer security window and click Allow

Step 5: Now, Our Excel File in our Local Machine

Note: This is not possible to import Excel file in QlikView, we need to create Network Location.

Step 6: We need to create Network Location

Step 7: Right Click on My Computer and select Add a network location option

Note: We have two option: 1) Add a network location and 2) Map network drive

Step 8: It shows, ‘Welcome to Add Network Location Wizard window’ and Click Next

Step 9: It shows, ‘where do you want to create this network location?’ Window and click Next

Step 10: It shows, ‘specify the location of your website’ window.

Step 11: copy the link from Windows Explorer (Step 5) and paste it in Internet or Network address and click Next.

Step 12: It shows, ‘what do you want to name this location?’ Window and click Next

Note: You can change the Location name before click Next.

Step 13: Click Finish

Finally, it will added in our local machine

Note: You can find the Network Location Press window + E

Import Excel File in QlikView from SharePoint

Step 1: Open QlikView Script Editor

Step 2: Click Insert menu and choose Load from File option

Step 3: Choose the Excel file from Network Location

Step 4: Click Finish


Lawrance A

Comments
beck_bakytbek
Master
Master

Thanks for sharing,

very interesting and powerful at the same time

0 Likes
lawrance
Creator II
Creator II

Thanks...

Regards,

Lawrance A

0 Likes
nithya123
Contributor II
Contributor II

very useful to me thanks.

0 Likes
d_koti24
Creator II
Creator II

Hi Lawrance A

Thanks for Informatiom,

but i am not able to get the file time and file size information in qlikview with FileTime(),FileSize() functions

i need that information from Sharepoint How to Achieve this please suggest.

0 Likes
Version history
Last update:
‎2016-10-12 05:49 PM
Updated by: