# Excel Upload - Only Import Values **URL:** \ **Category:** Ignition\ **Tags:** perspective\ **Created:** [June 23, 2025, 3:40pm UTC](https://forum.inductiveautomation.com/t/excel-upload-only-import-values/107677 "2025-06-23T15:40:15Z")\ **Posts on this page:** 1\ **Showing post:** 2
**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\ **Post date:** [June 23, 2025, 4:58pm UTC](https://forum.inductiveautomation.com/t/excel-upload-only-import-values/107677/2 "2025-06-23T16:58:20Z")
Generally, Excel caches the values of cells that are computed, and those cached values can be deliberately targeted by the Apache POI libraries. However, saving the cached value with the spreadsheet is not **required** , so you may need to execute the formula. Unfortunately, Apache POI is a memory hog, and any solution to this will result in a memory spike. Consider using a single dedicated thread to do such imports, so you can't get multiple users/tabs running at once. You **can** go directly from the imported sheet (in memory) to a "Prep" query, so that one-time spike is it. If you are feeling brave, look at this topic: > [@Upload and process large Excel files in perspective without massive memory usage](https://forum.inductiveautomation.com/t/upload-and-process-large-excel-files-in-perspective-without-massive-memory-usage/106823): > > Hi! I´m trying to create an app that processes some Excel files uploaded by the user. I have and UploadFile component with an event that sends the file bytes (file\_data = event.file.getBytes()) to the following function: from java.io import ByteArrayInputStream from org.apache.poi.xssf.usermodel import XSSFWorkbook from java.util import ArrayList from java.lang import String def read\_excel\_bytes(bytes): stream = ByteArrayInputStream(bytes) workbook = XSSFWorkbook(stream) sheet = workbook… --- _[View the full topic](https://forum.inductiveautomation.com/t/excel-upload-only-import-values/107677)._