[{"_1":2,"_183":-5,"_184":-5},"loaderData",{"_3":4,"_92":93,"_150":151,"_182":-5},"root",{"_5":6,"_33":34,"_59":60,"_90":91},"ctx",{"_7":8,"_18":19,"_20":-5,"_21":22,"_23":24,"_25":26,"_27":26,"_28":26,"_29":30,"_31":32},"auth",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"sessionClaims","sessionId","userId","actor","orgId","orgRole","orgSlug","orgPermissions","factorVerificationAge","environmentVariableKeys",[],"user","preferences_keybindings","default","preferences_theme","light","preferences_fixers",false,"preferences_copilot","preferences_selection_ai","preferences_model","claude-3-5-haiku-20241022","notification_count",0,"ENV",{"_35":36,"_37":38,"_39":40,"_41":42,"_43":44,"_45":46,"_47":48,"_49":50,"_51":52,"_53":54,"_55":56,"_57":58},"REACT_APP_SENTRY_DSN","https://586020d86f05489db63a554690acf1e9@o1398359.ingest.sentry.io/6724499","VAL_RUNTIME_NAME","prod","RENDER_GIT_COMMIT","4a6cf7de2f6415ba1b99e16e2b6953262c3d8375","RENDER_GIT_BRANCH","main","CLERK_PUBLISHABLE_KEY","pk_live_Y2xlcmsudmFsLnRvd24k","POSTHOG_API_TOKEN","phc_nmoyuAkStEZuUp69rYlg1DZgrIt19Gx0Y4Hwf8tGgJP","POSTHOG_API_HOST","https://wart.val.town","WEB_API_TEMPLATE","https://{val}.web.val.run","APP_URL","https://www.val.town","MODULE_URL","https://esm.town","API_URL","https://api.val.town","WORKER_FINGERPRINT","d0746fd0512e0614e3f717607f0da4cd","clerkState",{"_61":62},"__internal_clerk_state",{"_63":64,"_65":44,"_66":67,"_68":67,"_69":26,"_70":67,"_71":67,"_72":67,"_73":67,"_74":67,"_75":67,"_76":67,"_77":67,"_78":79,"_88":26,"_89":26},"__clerk_ssr_state",{"_9":-5,"_10":-5,"_11":-5,"_12":-5,"_13":-5,"_14":-5,"_15":-5,"_16":-5,"_17":-5},"__publishableKey","__proxyUrl","","__domain","__isSatellite","__signInUrl","__signUpUrl","__afterSignInUrl","__afterSignUpUrl","__signInForceRedirectUrl","__signUpForceRedirectUrl","__signInFallbackRedirectUrl","__signUpFallbackRedirectUrl","__clerk_debug",{"_80":26,"_81":67,"_82":83,"_84":67,"_85":44,"_86":26,"_87":67},"isSignedIn","proxyUrl","reason","session-token-and-uat-missing","message","publishableKey","isSatellite","domain","__telemetryDisabled","__telemetryDebug","remixVersion",2,"routes/_app.v.$handle.$name",{"_94":95,"_96":97,"_95":98,"_145":-5,"_146":-5,"_147":148,"_131":132,"_139":109,"_101":102,"_99":100,"_120":-7,"_51":52,"_149":26},"type","val","author","8d6857d3-cf1c-4e98-a094-0e379c10badf",{"_99":100,"_96":97,"_101":102,"_103":104,"_105":-5,"_106":107,"_108":109,"_110":111,"_112":113,"_114":26,"_115":113,"_116":117,"_118":119,"_120":32,"_121":26,"_122":32,"_123":32,"_124":32,"_125":126,"_127":32,"_128":32,"_129":-5,"_20":130,"_135":-5,"_136":-7,"_137":138,"_139":109,"_140":141},"name","csvViewer","valNameId","e88f4c58-6519-11ef-809a-de64eea55b61","parentFolderId","c6bc0940-713f-11ef-a1a4-de64eea55b61","isOwned","privacy","public","readme","client side csv viewer","valType","http","currentVersion","e8922b30-6519-11ef-809a-de64eea55b61","legacyPrivate","id","code","/**\n * This application creates a CSV viewer using a Hono app that serves a client-side application.\n * It allows users to upload a CSV file, view its contents in a table format, and provides basic sorting functionality.\n * \n * The approach:\n * 1. Create a server-side Hono app to handle file uploads and serve the HTML, CSS, and JavaScript.\n * 2. Implement client-side JavaScript to handle file reading, parsing CSV, and displaying the data in a table.\n * 3. Add sorting functionality to allow users to sort the table by clicking on column headers.\n * \n * Libraries used:\n * - Hono for the server-side application\n * - Papa Parse (via esm.sh) for parsing CSV on the client-side\n */\n\nimport { serve } from 'https://esm.town/v/g/serveUtils';\nimport { Hono } from 'npm:hono';\n\nfunction html() {\n /*\n\n\n\n \n \n CSV Viewer\n \n \n\n\n

CSV Viewer

\n \n

\n\n\n */\n}\n\nfunction css() {\n /*\nbody {\n font-family: Arial, sans-serif;\n line-height: 1.6;\n margin: 0;\n padding: 20px;\n background-color: #f4f4f4;\n}\n\n.container {\n max-width: 800px;\n margin: 0 auto;\n background-color: #fff;\n padding: 20px;\n border-radius: 5px;\n box-shadow: 0 0 10px rgba(0, 0, 0, 0.1);\n}\n\nh1 {\n text-align: center;\n color: #333;\n}\n\ninput[type=\"file\"] {\n display: block;\n margin: 20px auto;\n}\n\ntable {\n width: 100%;\n border-collapse: collapse;\n margin-top: 20px;\n}\n\nth, td {\n padding: 12px;\n text-align: left;\n border-bottom: 1px solid #ddd;\n}\n\nth {\n background-color: #f2f2f2;\n font-weight: bold;\n cursor: pointer;\n}\n\nth:hover {\n background-color: #e6e6e6;\n}\n\ntr:nth-child(even) {\n background-color: #f8f8f8;\n}\n\ntr:hover {\n background-color: #f0f0f0;\n}\n */\n}\n\nfunction js() {\n /*\nimport Papa from 'https://esm.sh/papaparse@5.4.1';\n\nconst fileInput = document.getElementById('csvFile');\nconst tableContainer = document.getElementById('tableContainer');\n\nlet currentData = [];\nlet currentHeaders = [];\n\nfileInput.addEventListener('change', handleFileUpload);\n\nfunction handleFileUpload(event) {\n const file = event.target.files[0];\n if (file) {\n Papa.parse(file, {\n complete: function(results) {\n currentData = results.data;\n currentHeaders = currentData[0];\n displayTable(currentData);\n }\n });\n }\n}\n\nfunction displayTable(data) {\n if (data.length === 0) return;\n\n const headers = data[0];\n const rows = data.slice(1);\n\n let tableHTML = '';\n headers.forEach(header => {\n tableHTML += ``;\n });\n tableHTML += '';\n\n rows.forEach(row => {\n tableHTML += '';\n row.forEach(cell => {\n tableHTML += ``;\n });\n tableHTML += '';\n });\n\n tableHTML += '

${header}
${cell}

';\n tableContainer.innerHTML = tableHTML;\n\n document.querySelectorAll('th').forEach(th => {\n th.addEventListener('click', () => sortTable(th.dataset.column));\n });\n}\n\nfunction sortTable(column) {\n const columnIndex = currentHeaders.indexOf(column);\n if (columnIndex === -1) return;\n\n const rows = currentData.slice(1);\n rows.sort((a, b) => {\n if (a[columnIndex] < b[columnIndex]) return -1;\n if (a[columnIndex] > b[columnIndex]) return 1;\n return 0;\n });\n\n displayTable([currentHeaders, ...rows]);\n}\n */\n}\n\nconst app = new Hono();\napp.get('/', serve(html, 'text/html'));\napp.get('/styles.css', serve(css, 'text/css'));\napp.get('/main.js', serve(js, 'text/javascript'));\n\nexport default app.fetch;","createdAt",["D",1724834742222],"version","currentUserHasLiked","likeCount","forkCount","referenceCount","dependencyCount",1,"commentCount","prCount","mergedPr",{"_131":132,"_133":134},"handle","g","profileImageUrl","https://img.clerk.com/eyJ0eXBlIjoicHJveHkiLCJzcmMiOiJodHRwczovL2ltYWdlcy5jbGVyay5kZXYvdXBsb2FkZWQvaW1nXzJqRlBqSjdFTUlTVmVORmpObmFqZmJLVWh5VCJ9","forkedVal","interval","slug","g/csvViewer","description","versions",[142],{"_120":32,"_143":-5,"_118":144,"_115":113},"prId",["D",1724834742222],"recentThread","breadcrumbs","comments",[],"isOwner","routes/_app.v.$handle.$name.versions.$(version)",{"_94":152,"_131":132,"_99":100,"_20":153,"_149":26,"_95":157,"_140":164,"_120":-5,"_177":32,"_178":179,"_180":126,"_181":-5},"list",{"_115":97,"_131":132,"_118":154,"_155":156,"_133":134},["D",1677277778175],"bio","Hi, I'm Gabriel 👋",{"_99":100,"_96":97,"_101":102,"_103":104,"_105":158,"_106":107,"_108":109,"_110":111,"_112":113,"_114":26,"_115":113,"_116":117,"_118":159,"_120":32,"_121":26,"_122":32,"_123":32,"_124":32,"_125":126,"_127":32,"_128":32,"_129":-5,"_20":160,"_135":-5,"_136":-7,"_137":138,"_139":109,"_140":161},true,["D",1724834742222],{"_131":132,"_133":134},[162],{"_120":32,"_143":-5,"_118":163,"_115":113},["D",1724834742222],[165],{"_115":113,"_116":117,"_120":32,"_118":166,"_167":100,"_101":102,"_110":111,"_131":132,"_11":97,"_168":-5,"_169":-5,"_170":-5,"_149":26,"_137":138,"_171":-5,"_172":173},["D",1724834742222],"valName","deletedAt","messageId","threadId","previous","stats",{"_174":175,"_176":32},"additions",175,"deletions","page","pageSize",8,"total","redirect","routes/_app","actionData","errors"]

csvViewer

Versions

v0