Articles in this section
Category / Section

How to change the language of OLAP Cube connected in Excel in .NET MVC PivotClient ?

5 mins read
  1. .NET  On the Data tab in Excel: Select From Other Sources -> From Analysis Services.
  2. Enter the Server name and click Next.
  3. Select the OLAP Server database and Cube that you want to use and click Next.
  4. In the File Name, click Browse... -> Copy the path from the address bar, for example 'C:\Users\[username]\Documents\My Data Sources'. Click Save, Finish and OK.

 

 

  1. By using Windows Explorer, open the path copied from the address bar (as pointed in step 4) and locate the *.odc file in the directory. Then open this file in Notepad.

 

 

  1. At the end of the <odc:ConnectionString> node, you can findLocale Identifier=[code] 

<odc:ConnectionString>Provider=MSOLAP.4;Integrated Security=SSPI;Persist Security Info=True;Data Source=.;Initial Catalog=OLAP;Locale Identifier=1033</odc:ConnectionString>


 

  1. Edit, save and close the connection file.
  2. Open a new WorkBook in Excel.
  3. On the Data tab, click Existing Connections, locate the edited connection file and click Open. This connection uses the new Locale setting.

 

Conclusion

I hope you enjoyed learning about how change the language of OLAP Cube connected in Excel in .NET MVC PivotClient.

You can refer to our .NET MVC featuretour page to know about its other groundbreaking feature representations and documentation, and how to quickly get started for configuration specifications. You can also explore our WPF example to understand how to create and manipulate data.

For current customers, you can check out our components from the License and Downloads page. If you are new to Syncfusion, you can try our 30-day free trial to check out our other controls.

If you have any queries or require clarifications, please let us know in the comments section below. You can also contact us through our support forumsDirect-Trac, or feedback portal. We are always happy to assist you!


Did you find this information helpful?
Yes
No
Help us improve this page
Please provide feedback or comments
Comments (0)
Please sign in to leave a comment
Access denied
Access denied